Skip to Content
avatar image
Former Member

DS 1.6 combined stacked line chart.

All,

I created a Combined stacked column chart with a line. The line chart shows the actual and the stacked column shows Target and x-axis shows sales group and the legend color is sales tiers which has three tiers. When i display the chart, the bars are showing individual values in the bar instead of cumulative stack. Please advise.

For example :

Tier 1 value : 500

Tier2 value: 600

Tier3 value : 800

The chart should show stacked with three tiers :

Tier1 plot: 500

Tier2 plot: 600 (600 on the scale)

Tier3 Plot: 800 (800 on the scale)

The chart currently shows:

Tier1 plot: 500

Tier2 plot: 600 (1100 on the scale)

Tier3 Plot: 800 (1900 on the scale)

Thanks,

Magesh Anandan.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Oct 31, 2016 at 09:39 AM

    Hi Tammy,

    Sorry for late reply. I am using an info chart component and it's DS 1.6 SP 2 .

    Thanks,

    Magesh Anandan.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 31, 2016 at 09:39 AM

    Hi Magesh,

    I think the error is because of aggregation of data in query, may be the keyfigure have cumulative sum aggregation on it.

    The stacked bar chart will show the data as in the initial view of data source, like you mentioned in your context.

    For your requirement, the data have to be like 500, 100, 200 respectively for Tier1, Tier2, Tier3. So change the data aggregation in query level.

    Thanks,

    Poovarsan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Magesh,

      The stacked bar chart itself will form a cumulative sum of the data, but your data is already aggregated so it displays wrong data.

      The stacked bar chart will automatically serve your purpose, there is no need of aggregation in data.

      Thanks,

      Poovarasan