count of results

[hopkinsc]

Hi all,

This is an easy one i'm sure but i cannot get it to work.

basically i have the following expression in a straight table with 'Name' as a dimension which gives the below result..

if(avg({<[Source_File_Name]={'Test'}, Date={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'}>}%Change)>=$(vKPIThreshold),

avg({<Source_File_Name={'Test'}, Date={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'}>}%Change),0)

there is a total of 47 rows in the above table.

what i want to do now is get a count of the rows in a text box, so i just want a text box that shows 47.

can anyone help?

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(If(Avg({<[Source_File_Name]={'Test'}, Date={'>=$(=date(vPreviousMonthStart))<=$(=date(vPreviousMonthEnd))'}>}%Change)>=$(vKPIThreshold),1, 0), Name))

[hopkinsc]

Thanks Sunny!