UX - Combination Chart

YaeshwiniVenkat

Edit View.png

Main Chart View.png

Module View.png

Value in line chart.png

Hi,
Good day!
I have a doubt in UX Stacked column chart with line chart.

[Please refer to the screenshots attached]

I have 2-line items namely 'Sales' and 'YoY%' with Sales as input and 'YoY%' as formulated one. 'A' and 'B' are list members of a list with C as top level. And I have time dimension with year.

Now, I need A and B to be in stacked column chart along with YoY% as line chart representing change year on year.

I see that if I bring line items in the rows, the line chart is possible for YoY% but stacked column chart is not satisfied for A and B. Can you help with this?

Also, is there any possibility to show the difference in values on top of the line chart (please refer to the screenshot, Name: Value in line chart, for the location of values to represent)

Thanks,
Yaeshwini Venkat

TimWard70

Trick here is to add a reporting module which converts the calculation by list into Line Items - see screenshots attached.

I set the YoY% as a "Dot" line on a second axis and changed the min\max to force the yellow dots to be above the chart, unfortunately, I can't show them in the middle of the trend line between years.

For the A & B lines I turned off the data labels.

Hope helpful

FinalChart.jpg

Reporting Module.jpg

Calculated Module.jpg