Count Expression?

[#1]

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.

[PabloOrtiz]

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)

[#3]

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

[Anonymous]

Hi,

Did you try to use dimension limit in your graph?

You can select option to show only the first 10% for exemple

[#5]

Bobbyraj,

I want it in Expression not in dimension

[Anonymous]

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

[#7]

Correct but here i am using a straight table with out any dimension and with only expression what i mentioned above in the question.