Jump to content

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

Share this post


Link to post
Share on other sites

Hi @Martyn Houghton

As a starting point, you should be able to do this on a list of counters widget relatively easily - I don’t have a huge dataset, but believe I have this working with the following set up:

 

66B152A4-31F5-4C78-8769-9E05C644EAC7.png

 

 

085FCFBE-A373-438E-8EF6-9A551ABD21E8.png

 

 

Kind Regards

Bob



 

Share this post


Link to post
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

×
×
  • Create New...