Hello! I have a workshop that displays a bar chart xy widget. the data displayed is from scenario manager like this:
I want to display a forecasted data beside the current year:
any input on how to do this? thank you in advance
any input on how to do this? thank you in advance
Hi @ianarceo. This should be possible with vanilla xy chart , but it will appear slightly different as in your 2nd screenshot. The trick is to set the bar chart into grouping and have both OT properties for the x-axis of the same type (timestamp-timestamp or string-string).
- best to start with a fresh widget
- set the first chart layer by using your scenario object set and set it to grouping. Note: I believe there is some bug with the xy chart configuration (or else I have not yet understood why this should be a feature): You have to configure this on the first layer and before adding an additional layer, else you will not be able to choose between stacked, grouped or percentage. To do this you can i.e put some property into the segment setting and remove it again. The grouped option will then be persisted.
- set your 2nd layer from the other OT „forecasted data“. Make sure to have both x-axis properties of the same type.
Since you have configured the chart to be grouped, the forecasted and scenario manager data will appear as individual groups within each x segment ( year). Years where your forecasted data is non existent will be blank (you will have a bit whitespace here)
If you need I can provide more clear instructions when I am at my laptop tmrw.
1 Like
thank you very much @Phil-M for the reply!
1 Like