Jump to content

Data chart widget - start of day sample period?


Recommended Posts

Hello,

I'm creating a data chart widget for first time fixes. I have used the Sql Group By option but there is no Sample Period for 'Start of this day'. How would I show how many first time fixes an analyst has done per day please? I have managed to do it for the week, but we'd really like it to show per day.

Many thanks,
Alisha

Link to post
Share on other sites

I have removed the 'Period Filtering' and applied h_dateresolved >= curdate() in the SQL filter.

However, I still need a way to enter h_createdby = h_resolvedby_user_id, but not sure how to do this properly. Could anyone help please?

Link to post
Share on other sites
  • 2 weeks later...

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...