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

[#1]

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_b which I have successfully used a table, but I am unsure how to write it up as a formula to filter between these times in a KPI.

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!)

Thanks!

[Anil_Babu_Samineni]

We are not know about data set? Some how try to use double quotes

Count({$<job_instance_end_time_b={">7:45<9:00"}>}job_instance_end_time_b)

[#3]

Sorry, not sure what you mean about data set? I have tried what you have put and it is not working.

[Anil_Babu_Samineni]

I mean how this field looks like? job_instance_end_time_b. Would you provide some sample file

[#5]

https://pcko365-my.sharepoint.com/personal/robb_parris_pickeringrelay_com/_layouts/15/guestaccess.as...

[Anil_Babu_Samineni]

For first one, Assume there is no values between the arbitrary. Can you check the values in text object where i define

Count({$<job_instance_end_time_b= {">=$(=Var1) <=$(=Var2)"}>}job_instance_end_time_b)

For second one

Count(${<job_instance_end_time_b={'>09:00'}>}job_instance_end_time_b)

[#7]

The first one comes up with 0, the second one seems to just count everything.

I know there is data within those ranges, as if I try to just look at specific times (like 8:45 for example) it comes up with a number that I would expect.

[Anil_Babu_Samineni]

May be manipulate this in script and reload for a while with in my application where i attach earlier

Load ...., ..., ...., Time(job_instance_end_time_b, 'hh:mm') as job_instance_end_time_b

[#9]

Put that in the data load editor, didn't seem to do anything (had to get rid of the ...., ..., ...., as it stopped the data load)

[Anil_Babu_Samineni]

My intention is here, Check in script from 87th line and replace it as below and reload then we can look? Becaue, If you notice "My New Sheet" then is one text box which is working using variable

    Time (end_time, 'hh:mm') as job_instance_end_time_b;