Qlik Community

Qlik Sense Cloud Discussions

Not applicable

Creating a KPI that shows how many items were finished within specific time ranges

Hi all

So, want I want to do is create a KPI that lets us know how many items were finished during our overtime periods (07:45 to 09:00).

I have job_instance_end_time which I have successfully used a table, but I am unsure how to write it up as a formula to filter between these time sin a KPI.

Thanks!

1 Reply
Not applicable

Re: Creating a KPI that shows how many items were finished within specific time ranges

Count({$<job_instance_end_time_b={'>7:45<9:00'}>}job_instance_end_time_b) is what I have so far, but this is not working as I had hoped (still learning this stuff!)

Community Browser