Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello dears,
i got a question, i already have a bar chart which shows the number of customers for each products,
the script for this chart is so easy, i have added Products field as dimension, in the expression i wrote count(Customers).
but i want to see the percentage instead of numbers. if i write the script like this:
count({<Product={A}>}Customers)/Count(Customers)
it shows the percentage of customers who bought Product A, but not every products.
thanks for your help in advance
Try like:
=Count(Customers)/Count( Total Customers)
Then in the number tab, check 'Show in Percent(%)' .
Try like:
=Count(Customers)/Count( Total Customers)
Then in the number tab, check 'Show in Percent(%)' .
Interesting, thanks buddy. i had not heard the Total term before.