Skip to Content
0

DS 1.6 combined stacked line chart.

Oct 29, 2016 at 08:29 PM

70

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded

Hi - are you using an InfoChart component or a Chart component? Can you use the image icon to upload issues? Which SP of DS 1.6 are you using?

0
Former Member
Tammy Powlas

I am using DS1.6 SP2. yes, we are using a Infochart component.

Thanks,

Magesh Anandan.

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

Hi Tammy,

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

Thanks,

Magesh Anandan.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 31, 2016 at 09:39 AM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Poovarsan,

Thanks for the response. Correct me if i am wrong. The stacked bar chart should serve the purpose of it. Even though the values are cumulative. the scale should be showing at the right data point.

Thanks,

Magesh Anandan.

0
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

0