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

    Show date not count with set analysis

    Phil Speight



      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.




      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?