Forum Discussion
Solved
Advanced Charts - Line chart showing several years by month
SOURCE: ONESTREAM CHAMPIONS Hi everyone, Has anyone used the Dashboards for advanced line charts to show a few years of actuals and the current year of budget? I am trying to show actuals for 2019,...
Cindy
This may be suitable to your question. Advanced Chart Type is XY2D. Cube view has UD8 members on the row and Time by month on the column. The UD8 members are essentially: Actual Current Year, Actual Prior Year, Budget Current Year etc. The dynamic calc for each member leverages T#POV to return the appropriate fiscal year.
Terry
I am using the Chart Advanced component to import into an Extended Document and want Actuals and Budget lines as well, separated. My question, how do you get your 2 lines for Actual and Budget not to dive to 0 when outside of their time range? Is this something you do in the UD8 dynamic calc? If so can you share the rule to get it not to show 0s. If the setting is in the Chart, can you share that as well? Thanks. Your suggestion is a good one here.