Displaying no of Rows

[Anonymous]

Hi

Can someone helping me in fixing the expression for displaying the total Rows in the table , I have 2 ways of selecting service api value , one from Group:Service API filter and other way from Function in the Table , when user selects a Service api (function)value from Table the total number of rows count messes up in the Caption , please take a look at the attached file

Thank you

[sunny_talwar · Accepted solution]

May be use this expression:

=Count(Aggr(If(vFilterCheck,

  If(only({<ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}RequestCount_All) >100,only({<ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}RequestCount_All))

,only({<ServiceTimeSeries.Date={'>=$(=Date(vStartDate))<=$(=Date(vEndDate))'}>}RequestCount_All) ), ServiceTimeSeries.Date, FCIGroup, Function, TP50, TP90, TP999))