Jump to content

SQL Distinct Widget or Measure


Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...