Ratio in a bar chart

[#1]

Hi guys

I'm still a rookie and need some simple help.

How can I show the ratio within a field in a bar chart every month?

Fx. for one month I have a field "PRODUCT" within the field i have "Product 1" "Product 2" etc. If I chose "Product 1" I can see that it has been sold 10 times(frequency), for "Product 2" 30 times(frequency) etc.

I want to make a bar that show the ratio between "Product 1" and the others. If we only had the two products for one month the ratio would be 10/30 = 33.3 %.

Please let me know if you need me to clarify anything

Thanks!

[Jason_Michaelides]

Sum(Frequency)/(Sum(TOTAL Frequency)-Sum(Frequency))

Hope this helps,

Jason

[sunny_talwar]

May be you need this:

Dimension:

MonthYearField

PRODUCT

Expression:

Count(PRODUCT)/(Count(TOTAL <MonthYearField> PRODUCT) - Count(PRODUCT))

[#4]

Hmm it doesn't work.

I have chosen Month and Product as dimension and as expression the text you have wrote.

The values are wrong and I get a bar chart with all the products I have, I only need to show Product 1 / Product(all products) and then on a monthly basis.

[Jason_Michaelides]

Sum(Frequency)/(Sum(TOTAL <Month> Frequency)-Sum(Frequency)) should work. Can you share your app please?

[sunny_talwar · Accepted solution]

Did you replace MonthYearField with Month? MonthYearField was a placeholder and needed to be replaced with the field you were using in your chart.

Like jason.michaelides‌ mentioned, try this

Sum(Frequency)/(Sum(TOTAL <Month> Frequency)-Sum(Frequency))

[MarcoWedel]

Hi,

one example might be:

or to avoid "Errors in expression" enumerating all fields of the dimension group in the total qualifier (instead of the group name itself):

One note: If you compared the sales of one product to the sales of all products (including itself), the usage of stacked bars might be an option:

hope this helps

regards

Marco

[#8]

It worked! Thanks!

[#9]

It's working - thanks!