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 · Accepted solution]

And what makes me really mad is if i put only Downloads, Uploads in Chart Expert- > Data -> Show values it produce correct output for the first item in the list ,since the last one is always a straight line 100% .

[Former Member · Accepted solution]

I think you are going to need some formual fields to replace the real fields

these can be adjusted .

NB you can use formula fields that do the summarizaration if you do tick the 'don't summarize' box

[Former Member]

Great , that helps. I add that graph as subreport since i have a graph in a group header where grouping on other field is implemented. Thank's a lot

[Former Member]

Dont summarize option is disabled , i mean is gray so no such option. That's more a question to the people who add that charts to designer . Is it suppose to work with 2 series at all??

Than's for you try.

[Former Member]

Don't summarize is gray because it only works on formulas and is designed for formulas which have already been summarised.

what I am recommending is that you get the numbers(percentages) calculated in formulas at the group level ( for the on change of axis )

then use these formulars ( then the button will not be grayed out).

the trick is getting the formulas, but start with group sum formulas for the three columns and then another set to do the percentage

[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

[Former Member]

not totally sure I fully understand.

could you show a sample of the raw data.

ie

month,total,upload,download

Jan,100,10,90

Feb,80,40,40

etc

just so I can get a 'handle' on it