Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want Count of Customers that contribute 10% of cumulative volume.
Here I have Volume Expression like below
Volume Expression : sum({<AsOfPeriod = {'>$(=date($(VMaxAsOFPeriod)-$(VDaysForTrending))) <=$(=date($(VMaxAsOFPeriod)))'},
same_day={'Y'}>} METRIC_VAL)
Here i want to calculate Count of Customers that contribute 10% of cumulative volume.
can u plz give me idea on this.
Hello, try this
count({<Customer = "=your_expression">} distinct Customer)
count({<Customer={"=sum({<AsOfPeriod = {'>$(=date($(VMaxAsOFPeriod)-$(VDaysForTrending))) <=$(=date($(VMaxAsOFPeriod)))'},
same_day={'Y'}>} METRIC_VAL)"}>} distinct Customer)
Thanks for the reply
But here i want 10%,20%,30% contributed customers only for each expression
for example 10% contributed customer ---- 1 expr
20% contributed customer ---- 2 expr
etc
Hi,
Did you try to use dimension limit in your graph?
You can select option to show only the first 10% for exemple
Bobbyraj,
I want it in Expression not in dimension
Yes but when you filter you dimension it will affect the expression.
In fact when you add option to select 10%, the graph will represent the dimension corresponding to the 10% of your expression
Correct but here i am using a straight table with out any dimension and with only expression what i mentioned above in the question.