Percentage Line Chart usage

[#1]

Hello Comunity. I have a task to create a chart which shows Total, Downloads , Uploads where Total = Downloads + Uploads in scale of month. Total of Items as are shown as 100% staraight line in chart , Downloads and Uploads are other 2 series to show as percentage ( Downloads +Uploads = 100%). So e.g. we have 3 mont Apr: Downloads:11 , Uploads:45 , May : Downloads:10 , Uploads:90 ...

The problem is that Percentage Line Chart is useless for that as it works correctly only if i use Total + Downloads, Total + Uploads in separate Charts.

I find out that what is done: if to place Downloads, Uploads, Total in order we have next: Downloads % = Downloads / (Downloads + Uploads+Total) ; Uploads% = (Downloads +Uploads) / (Downloads + Uploads+Total)

Anyone knows how to split two charts into one ???

Thank's Ruslan

[Former Member]

Sure

Region Country Month dow upl filt total

Americas NULL October 0 2 1 2

Americas NULL September 1 0 1 1

APJ NULL October 0 3 1 3

APJ NULL September 0 7 1 7

APJ China October 22 63 1 85

APJ India April 1 4 1 5

APJ India March 0 4 1 4

where filter is a field i use for grouping , place the chart into groupheader , and in Chart Expert create Percentage Line Chart .

So month - > in change of downloads,Uploads, Totals are calculated as summary because Month can duplicate for different Region/Countries. All that work fine , so i can see the data is ok, in case i place data labels in graph, but actual graph is not what i expect. See the formula above to undestand how it does calculations inside graph to have PERCENTAGE values.

That sounds it's a bug or i do something wrong?

Thank's