topic Bar Chart Percentages in App Development

Bar Chart Percentages

EvanBarrick — Wed, 26 Dec 2018 16:09:06 GMT

I have a bar chart with a dimension of 'Category'

the Measure is 'Conversions'

I am attempting to create a horizontal bar chart, on which i want each 'Category' to display it's percentage of 'Conversions'

For example, there a total of 400 'Conversions' and the 'Category' direct represents 100 'Conversions' so I would want that to display as 25%

skamath1 — Wed, 26 Dec 2018 18:28:38 GMT

Try Sum(Conversion)/Sum(Total Conversion) . Format the number as percentage.

lblumenfeld — Wed, 26 Dec 2018 17:24:40 GMT

See the attached example. I used

Sum(Conversions) / Sum(total Conversions)

and formatted the number as a percentage #,##0.0%

EvanBarrick — Wed, 26 Dec 2018 18:20:26 GMT

When I use this, the percentages do not end in the output I would expect.

Here is my actual data:

Category Conversion

Web 307

Referral 45

ESAB1 16

ESAB2 19

RG1 1

RG2 0

RG3 0

TW 1

Direct 0

So the total is 389. The percentage for the first category should be 79% but when I am getting 30%

skamath1 — Wed, 26 Dec 2018 18:28:00 GMT

Use the Sum function. It works

lblumenfeld — Wed, 26 Dec 2018 18:51:58 GMT

Are you sure you're using the formula I used? That should work, unless your chart has additional dimensions. Is it just Category as the dimension?

EvanBarrick — Wed, 26 Dec 2018 18:54:30 GMT

Problem was with my data, this functions.

My data file has a totals row that I was unaware of