topic Re: Creating buckets based on turnover in App Development

Creating buckets based on turnover

pschmidt1973 — Sun, 02 Apr 2017 00:20:49 GMT

Hi All

I have the following calculated dimension for Customer Rank:

=If(Aggr(Rank(Sum([Turnover])),[Customer ID])<=10,dual('Top 10',1),dual('Other',2))

Now I would like to create another calculated dimension for Turnover Rank, the buckets are based on:

- 50k+

- 30k to 50+

- 20k to 30k

- 10k to 20k

- 5k to 10k

- 1k to 5k

- <1k

hic how would I re-engineer the Customer Rank into a Turnover Rank.

Thanks, Paul

Re: Creating buckets based on turnover

Anonymous — Sun, 02 Apr 2017 10:52:30 GMT

Paul, Why cant we create the dimension in script?? I mean in script we can use if else clause adn create a field like you asked Turnover Rank.

Re: Creating buckets based on turnover

pschmidt1973 — Sun, 02 Apr 2017 22:54:58 GMT

Hi Shiva

It would work in the script for a static dimension, however, Turnover Rank is a dynamic calculation that will change based on user selections.

Regards, Paul

Re: Creating buckets based on turnover

sunny_talwar — Sun, 02 Apr 2017 23:53:21 GMT

Would you be able to share some raw data and explain what the desired output needs to look like for the data provided?

Re: Creating buckets based on turnover

pschmidt1973 — Mon, 03 Apr 2017 01:14:19 GMT

Hi Sunny

The basic premise is to group customer sales into buckets. Unfortunately, cannot provide data as it is customer data, however, it is based on the following:

- Group sales into buckets based on the following ranges for customer:

- 50k+

- 30k to 50+

- 20k to 30k

- 10k to 20k

- 5k to 10k

- 1k to 5k

- <1k

So the end user can select a list for example, Jan-2017, and the sales buckets will reflect sales in each bucket based on customer.

It's basically the opposite of the calculation I posted earlier.

Cheers, Paul

Re: Creating buckets based on turnover

sunny_talwar — Mon, 03 Apr 2017 01:22:11 GMT

All I was asking for was dummy (mocked up) data... if providing that isn't possible, then I am not sure I will have a good understanding of what you have. May be someone else can offer better help