UX - Combination Chart

YaeshwiniVenkat
YaeshwiniVenkat
in User Experience
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

Tagged:

Best Answer

  • TimWard70
    TimWard70
    Answer ✓

    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

Answers

Categories