03-28-2022 04:52 PM - edited 03-28-2022 04:52 PM
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 way to add a second axis on the right - so wondering if I can have two charts on the same pane.
Appreciate the help folks. Thank you!
03-29-2022 07:04 AM
Add your Avg Fleet Total measure to the Values pane and choose chart type and in the second tab of the chart type selection window you will have the option to plot it on a secondary axis as in the pic below.
03-29-2022 08:04 AM
I did - but how do I select avg fleet acct? I'm using a CV MD data adapter fyi.
03-29-2022 08:25 AM
Right you should create a calculated field with formula something like this..
Iif(StartsWith([Account]), 'Asset Yield Pct'), [Amount], 0) --Add all your account conditions for you Avg Fleet Acct
Make this Field Type Decimal and add this to your values pane and then choose Average as shown in the pic below
03-29-2022 09:00 AM
Thank you for your patience, @Sai_Maganti. I'm new to Dashboards building.
Where do I add this expression? - Iif(StartsWith([Account]), 'Asset Yield Pct'), [Amount], 0)
if you can show this setup within your expression/filter editor - that would help a lot.
03-29-2022 09:13 AM
Here we go. Once created add your expression and then rename it to what ever you want and then set the field type to decimal.
03-29-2022 09:43 AM
Yep found it. I'm getting this syntax error -
What am I doing incorrectly?
03-29-2022 10:36 AM
Look at my previous post. You're missing the "Iif" in the expression. Basically this expression is an if condition
03-29-2022 10:46 AM
03-30-2022 04:18 PM
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.
03-31-2022 01:35 PM
I don't understand what you meant by isolate 'Average Fleet" ??
03-31-2022 03:11 PM - edited 03-31-2022 03:11 PM
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.
03-31-2022 03:33 PM
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