6 Replies Latest reply: Mar 25, 2015 7:25 AM by Phil Speight RSS

    Show date not count with set analysis

    Phil Speight

      Hi

       

      I have created a table which shows a column how many DNA appointments there were in the last 7 days and a column which shows how many DNA appintments in the last 12 months.

       


      image1.jpg

       

      Is there any way I can show the date instead of the count of appointments for the last 7 days column.  See script below:

       

      =(

      Count({<[attendance description]={'DNA'},[appointment_date]={">=$(=date(today()-7)) <=$(=date(today()-1))"}>} distinct appointment_id))

       

       

      Any thoughts?

       

       

      Phil