6 Replies Latest reply: Sep 21, 2015 5:56 AM by Phil Speight RSS

    Set analysis - Convert from table to chart

    Phil Speight



      I currently have a table which contains a number of field and I have applied various filters to get the desired data.  As I need to create some charts I need to change this to set analysis so I can summarise the data.


      My current syntax is :


      if(VacProgress='In Progress' and

      (vacstate<>'Draft' and vacstate<>'In progress'and vacstate<>'Refused') and

      not wildmatch(empjobref, '*VCP*'),

      count(distinct esrempjobref))


      Can anyone help me change this expression so it works with set analysis?



      Many thanks