Jump to content
Sign in to follow this  
Alisha

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

Share this post


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?

Share this post


Link to post
Share on other sites

Hi @Alisha

What you have suggested all seems fine to me - if you are still having some issues with this one, please could you post a screenshot of what you've configured and the issue/error you get when trying to run it?

Kind Regards

Bob

  • Thanks 1

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
Sign in to follow this  

×
×
  • Create New...