Comprehensive Multi-Column Visualization for Nextcloud Analytics

[bijan-behvandi]

Is your feature request related to a problem? Please describe.
As an HR professional utilizing the Nextcloud Analytics app, I face a significant technical limitation that hinders my ability to perform thorough data analysis. My department requires the comparison of numerous data points to generate meaningful insights. For example, I need to analyze up to 20 different columns simultaneously, such as Monthly_Salary, Work_Experience_Years, Remaining_Leave_Days, Performance_Score, and Training_Hours, against a single dimension like Employee_ID or Job_Unit.

The current app's interface limits me to selecting only two columns (Column 1 and Column 2) for visualization. This forces me to create over a dozen separate, fragmented charts to compare all necessary metrics, which is inefficient and impractical for generating comprehensive reports. This constraint prevents a unified view of employee data, making it impossible to quickly identify correlations and trends.

Describe the solution you'd like
I would like the Analytics app to support the visualization of multiple numerical columns against a single categorical dimension. The ideal solution would be a feature that allows users to select an array of value columns (e.g., up to 20 columns) and represent them as a single, unified chart. This could be achieved through a grouped bar chart or a similar format.

This enhancement would allow HR professionals to create powerful, multi-dimensional dashboards. For instance, I could generate a single chart that shows Monthly_Salary, Performance_Score, and Training_Hours for a group of employees side by side.

Describe alternatives you've considered
I have explored potential workarounds, but none offer a scalable, long-term solution:

Manual Data Pivoting: I can manually transform my dataset from a wide format to a long format, combining all 20 metrics into a single Metric column and a Value column. While this allows the current app to display the data, it is a tedious and time-consuming process that requires manual intervention for every new dataset. It also makes the data structure less intuitive for other users.

External BI Tools: The alternative is to export our data and use external Business Intelligence tools. This adds an extra layer of complexity and completely undermines the value of having an integrated analytics solution within the Nextcloud ecosystem.

Additional context
This feature is not merely a convenience; it is a fundamental requirement for modern data-driven HR and is a widely expected capability in any robust analytics application. Implementing this change would significantly increase the value and professional utility of the Nextcloud Analytics app for the entire enterprise community, enabling more sophisticated analysis without needing external solutions.

Thank you for your consideration.