Hi Team,
I have resources tracking hours on a daily basis. When it comes to monthly reporting, I need to show the overall overtime hours in a KPI for those who tracked more than expected. I have attached a sample input where the extra overtime hours (35) need to be displayed in the KPI. Additionally, out of the 3 resources, 2 resources recorded overtime for that month. I also need a KPI to show the number of over-utilized resources (which are the 2 resources).Can you please help me here.
Hello @hellosai321
Looking at your dataset, have you tried adding your ot to a KPI visual and filtering for the selected date range?
As far as showing a count of resources where ot = 0, you can add that to an ifelse statement:
distinct_count((ifelse({ot} = 0, {resource},null))
Hi @duncan ,
I tired but it is not working as expected.
Can you please implement that in above analysis..
Hey @hellosai321
What didn’t work? Did the visuals not return the correct values or did you run into an error?
Hey @hellosai321
It’s been awhile since we have heard from you so this topic will be archived. If you still need help on this problem please feel free to post a new topic in the community so that it will be a priority. You can link this topic in your new post.