How can I include a color dimension in an overlay chart?

Mary Hall McArver shared this question 6 years ago
Answered

I am trying to use an overlay chart to display multiple lines of a line graph over a bar chart. I need to split one of the metrics by another dimension creating multiple lines with different colors. I am attaching a screenshot of the graph I am trying to re-create in Yellowfin as well as what I have so far in Yellowfin. I want to add the 'Place of Service' field to the Yellowfin chart to break down the 'Visits per K'.

Thanks in advance for your assistance,

Mary Hall

Replies (1)

photo
1

Hi Mary,

The "Set analysis" feature was specifically designed to help you with this sort of thing.

https://community.yellowfinbi.com/knowledge-base/article/7-3-set-analysis-feature_1

This allows you to basically create new calc fields at the chart level. This is new to 7.3 so if you are on an earlier version you will need to create these calculated fields manually:

case when my_dimension='office' then 'visits per k' end
case when my_dimension='out patient' then 'visits per k' end
 

Let me know if this looks like it will work.

Regards,

Nathan

photo
1

That worked! Thank you so much for your help. It looks perfect now.

Best,Mary Hall

photo
1

Hi Mary,

Awesome! Glad to hear it, and no problem.

Nathan

photo
Leave a Comment
 
Attach a file