18 Replies Latest reply: Oct 15, 2015 2:41 AM by Kumar Pramod RSS

    filtering through set analysis.

    Kumar Pramod

      Hi all,

       

      I have a 4 KPI's in my sheet and two filter pane.

      each one refers to the different counts and filter pane is for client and batch.

      when i filter through the client filter pane the count shows only for that client.

       

      i have a different start date for the different clients/batch. when i select the particular client the data should filter.

      like >= startdate of that client/batch.

      and without any filter it should show the all the values.

       

      How can i use the set analysis?

       

      Currently i am using below expression :  Count({$<DateType = {invitation}>}invitation_id)

       

      I tried with the new expression :  Count({$<DateType = {invitation}, canonicaldate = {'>=date(start_date)'}>}invitation_id)

      It's working for client specific, but without client specific i need all the counts.

       

       

      Regards,

      Pramod