I have had several requests from users regarding the layout of period and Variance & Period Variance modes. I have opted to put them into one feature request rather than multiple. I believe these options could also be applied on pretty much all the modes.
Firstly, although custom mode could work, when you look at it on a dashboard we loose the ability to choose a custom period. In effect the custom widget would become static. In a lot of cases, having the widget more configurable (show/hide elements) it would take away a lot of the layout headaches.
Period Mode - Total Column (On/Off)
The total column (first on left) to not be present on period mode. Specifically on month trending, they may be looking at the period values only and the total is not relevant. This is especially true on dashboards, if the default is rolling 12 months and user switches to a custom period of current Fiscal year we get the total and the FY column repeating same values twice.
Can we have an new “option” in the Widget menu to suppress the total column please?
Variance Mode - Previous/Variance /% Variance (On/Off)
With this mode, its very useful, but quite often (depending on who you talk to in the business!) the columns are not all required. For example one user would say they don’t care about “% Var” and only want the “Var” value and vice versa. Or don’t want to see the previous value at all and only show Current and “% Var”. It would be extremely beneficial to have options to turn on which columns you wish to display.
This is especially useful if we looked at Period Variance, this would considerably reduce the size:
How it could work
Within the widget design, I propose that in the “options” gear icon there is a new menu option to allow you to configure the columns to display:
I believe this should not only provide the designer more control, it could potentially reduce render time to display and allow better use of the dashboard area.
Please let me know what you think?