Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I would like to create a cake chart representing % of increasing , % of decreasing and % of flat customers.
Increasing: number of customers that are growing current year units sold vs prior year units sold: criteria is >10% growth
Decreasing: number of customers that are decreasing current year units sold vs prior year units sold: criteria is <-10% growth
Flat: number of customers that report flat trend for current year units sold vs prior year units sold: criteria is between +10% and -10% growth
Furthermore, I want the possibility to sort by period/months (e.g. select Jan, feb, or select Jan, Feb, Mar,...)
Find attached the database source.
could you please help me in figure out how to do it?
thank you
Jessica
Hi Jessica,
Great question, easily solved through the magic of set analysis.
The below example shows how to count just the (unique) accounts with a sales increase of over 10%, compared to the previous year.
Count(
{<Account =
{"=(sum({<Year = {'$(=Max(Year))'}>}[Net Sales])-sum({<Year = {'$(=Max(Year)-1)'}>}[Net Sales]))/sum({<Year = {'$(=Max(Year)-1)'}>}[Net Sales]) > 0.1"}
>} DISTINCT Account)
I've atttached an app with your data and the chart you're trying to create.
Kind regards,
Ronald