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
Mustafa_A
4 years agoContributor II
BI Viewer - Creating a clustered column line chart
Hey All, I'm trying to add a column (bar) chart on top of this line chart. But I want it to reference and add a dollar based stats account (e.g. Avg Fleet Total) bar chart. I noticed there is a wa...
Mustafa_A
4 years agoContributor II
Yep found it. I'm getting this syntax error -
What am I doing incorrectly?
Sai_Maganti
4 years agoContributor II
Look at my previous post. You're missing the "Iif" in the expression. Basically this expression is an if condition
- Mustafa_A4 years agoContributor II
- Mustafa_A4 years agoContributor II
Hey Sai_Maganti
Again, thank you for you help.
I have the expression correct - however how do I isolate it to 'Average Fleet'
The field type is set to decimal, and have second axis on.
- Sai_Maganti4 years agoContributor II
I don't understand what you meant by isolate 'Average Fleet" ??
- Mustafa_A4 years agoContributor II
Apologies if I wasn't clear.
When I use this calculated field (expression) and add it to the value pane. It doesn't bring in any values from Average Fleet Total.
I'm looking to grab the avg fleet values and plot in on the x and y axis as a column chart.
- Sai_Maganti4 years agoContributor II
You need to check your data for Account "Average_Fleet_Total" and why it is not returning any data. Add a grid view component within this chart and drag this calculated measure and see what's the data like