9 Replies Latest reply: Aug 4, 2017 4:13 PM by Mary Jo Taft RSS

    Set Analysis with variables

    Nisha Nangalia

      Hello All,

       

      We are trying to improvise a dashboard

       

      Set Analysis expression looks like :

       

      =(if(Match(

      [Task Name],

      'ABC',

      'FMG',

      'ELT',

      ),1,(if(Match([Task Name],'PF'),Count({<Distribution={1},[Task Category]={"main","sub"},[Task Name]-={'*Distribution*','*Tiina*','*new Report*',  '*housekeeping*'},Node_TS_Date={">=$(=Date(Today()-30))<$(=Date(Today()))"}, [Task Status]={'Completed', 'Warning','Failed'}>}Node_TS_Hour),2)))

       

      I want to use variables in this for reuse purpose.

      vCategory = [Task Category]={"main","sub"}

      vTaskName = [Task Name]-={'*Distribution*','*Tiina*','*new Report*',  '*housekeeping*'}

      vTaskStatus = [Task Status]={'Completed', 'Warning','Failed'}

      vTaskOneDay Match([Task Name],'ABC','FMG','ELT',)


      I am unable to create a set analysis expressions with these variables.


      I have put this in one variable


      vExpectedPCG = if(Match([Task Name],'PF'),Count({<Distribution={1},[Task Category]={"main","sub"},[Task Name]-={'*Distribution*','*Tiina*','*new Report*',  '*housekeeping*'},Node_TS_Date={">=$(=Date(Today()-30))<$(=Date(Today()))"}, [Task Status]={'Completed', 'Warning','Failed'}>}Node_TS_Hour),2)


      =if((=$('vTaskOneDay')),1, $(=vExpectedPCG))


      It is giving result for all except vTaskOneDay  part.


      Can someone please help on this.