Search the Community
Showing results for tags 'count'.
I am trying to work out whether it is possible in either Analytics Measures or Widgets to get a count of distinct external organisations which have logged request in the last 12 month. I can get a count of requests logged in the last 12 month withe the following:- h_org_id<>0 and h_datelogged>(DATE_SUB(now(), INTERVAL 12 MONTH)) h_org_id<>0 and h_datelogged>(DATE_SUB(now(), INTERVAL 12 MONTH)) But as I am not able to write the SQL and insert the distinct(h_org_id) or group by on a count, I struggling to work out how to get this to be displayed as either a measure or widget. Cheers Martyn
Hi I am trying to create a widget to show a count of all the open incidents. (see attached). I am getting a figure however it doesn't match the figure the analyst view (see attached). So I would expect the widget to show a total of 216 to match the information on the analyst view but I am getting a different number (I am getting 217) Please can you help me Sonali