Skip to Content
author's profile photo Former Member
Former Member

Percentage Line Chart usage

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2011 at 11:55 AM

    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% .

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2011 at 01:12 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2011 at 11:07 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2011 at 11:48 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 21, 2011 at 09:18 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.