We currently have a large amount of data stored in Smartsheet and use Power BI to visualise and report on it. We would really like to move more of our reporting directly into Smartsheet, particularly as we see the platform continuously improving and adding new capabilities.
One of our key reporting requirements is to track how each product is performing week by week, often using percentage breakdowns to clearly understand changes in performance.
It would be extremely valuable if Enhanced Charts could support the following:
- Stacked bar charts
- 100% stacked bar charts to show percentage breakdowns
- The ability to display counts or percentages based on the user's preference
- The ability to choose whether values are calculated/displayed against the grand total
- Greater control over the Y-axis range, including the ability to manually set minimum and maximum values
In particular, being able to control the Y-axis would make it much easier to compare performance between weeks. Automatically scaled axes can sometimes make relatively small changes look significant, or hide meaningful differences.
These improvements would make Smartsheet much more powerful for operational reporting and could reduce our reliance on Power BI for many of our day-to-day reporting needs.
