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

    Set analysis - Convert from table to chart

    Phil Speight

      Hi

       

      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

       

       

       

      Phil