Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a column indicating the total sales amount and I would like to straify it and show it as seen below. Which would be the best way to go ? Any help would be appreciated
Strat Indicator | Transaction Amount | Transaction Count | |
---|---|---|---|
< 100k | (total transaction amount for this range) | (number of transactions within this range) | |
100-200k | (total transaction amount for this range) | (number of transactions within this range) | |
200-300k | (total transaction amount for this range) | (number of transactions within this range) | |
>300k | (total transaction amount for this range) | (number of transactions within this range) |
Thanks
with class function?
from online help
class(expression, interval [ , label [ , offset ]])
Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.
Examples:
class( var,10 ) with var = 23 returns '20<=x<30'
class( var,5,'value' ) with var = 23 returns '20<= value <25'
class( var,10,'x',5 ) with var = 23 returns '15<=x<25'
Can you provide some source data or qvw ? its possible.
with class function?
from online help
class(expression, interval [ , label [ , offset ]])
Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.
Examples:
class( var,10 ) with var = 23 returns '20<=x<30'
class( var,5,'value' ) with var = 23 returns '20<= value <25'
class( var,10,'x',5 ) with var = 23 returns '15<=x<25'
Hi Jonathan,
The source file can be anything as long as it contains a numeric column having values. I would like to stratify that column and have a table as shown in the dashboard.
Hi Massimo Grossi,
Thank you. The class function was what I was looking for. I figured I need to create a calculated dimension and it worked.