Data chart widget - start of day sample period?

[Alisha]

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

[Alisha]

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?

[Bob Dickinson]

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