Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement in the UI can't modify the back-end script.
In the below sample source file i need to calculate the Count of Red Ind in the text box with the expression like count of Red Ind aggregated by Metric Group and Metrics for all the Months.
Requirement with expected output:
By default, it should total red count for all months =10 based on unique Metric Group and Metrics
if user select
June month then it will show >> 2 (as red count is repeated for Met 12 two time need to pick only 2 rows out of 3 rows in June month)
>> July -- 3
>> Aug -- 1
>> Sep -- 1
>> Oct --1
>> Nov -- 2
Please find the attched sample soure file Please provide the solution in the app.
Thanks in advance.
May be this (again I don't understand why Aug = 1 and total is 10)... I would have thought the total to be 11 and Aug = 2
Sum(Aggr(Count(DISTINCT Metrics), MonthYear))
Hello,
I don´t understand exactly how you come to a count of 10 and for august of a count of 1.
Would you count for a combination of metric group and metrics?
Then you can create a extra field in your load script like:
"Metric Group"&' '&Metrics as MandM, |
And use
count(aggr([Red Ind],MandM))
to count it
In the other case you can use:
count(aggr(aggr("Red Ind",Metrics),[Metric Group]))
to aggregate both of them
May be this (again I don't understand why Aug = 1 and total is 10)... I would have thought the total to be 11 and Aug = 2
Sum(Aggr(Count(DISTINCT Metrics), MonthYear))