The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Charts
Does anyone have any experience creating a bar graph with 2 dimensions on the x axis?
We have created a bar chart comparing Recurring and non recurring revenue by entity.
Currently, I have both...
Unless there is a particular reason to use Advanced Charts, I would suggest to use Bi Viewer instead, in combination with a Data Adapter of type Cube View MD. For most types of charts, is usually much easier and more intuitive to work with that setup, than trying to get Advanced Charts to behave.
Two options:
1) In the Data Adapter Settings > Miscellaneous > Add Start End Calendar Time: set to True. This will give you fields of StartDate and EndDate which are real date values that will sort properly
2) Convert the OneStream [Time] field to a DateTime in a Calculated Field. For example: ToDateTime([Time]), this requires that the Data Adapter > Header Text > Time: is set to Description.
Once you have a real date to work with you can format in your BI Viewer component to your preferred format, such as, Month-Year.
Thanks Jack!
I was able to convert the chart using BI Viewer. I am now getting the chart I want. However, when I assign the time parameter in the cube view: T#Month(|CVTime|), T#MonthPrior1(|CVTime|), T#MonthPrior2(|CVTime|) it is now formatting the months in alphabetical order than than in order of months. Any further advice here?
Two options:
1) In the Data Adapter Settings > Miscellaneous > Add Start End Calendar Time: set to True. This will give you fields of StartDate and EndDate which are real date values that will sort properly
2) Convert the OneStream [Time] field to a DateTime in a Calculated Field. For example: ToDateTime([Time]), this requires that the Data Adapter > Header Text > Time: is set to Description.
Once you have a real date to work with you can format in your BI Viewer component to your preferred format, such as, Month-Year.