Imaging that i have the data:
time. Person. Hours. limit of hours
datatime1 person1 5 6
datatime1 person2 7 6
datatime1 person3 5 6
datatime2 person1 9 6
datatime2 person2 5 6
datatime2 person3 20 6
And i want to count how many people crossed the limit on the most recent update.
I tried to use a filter Hours > limit of hours in discover, but seems that it didn't work as nothing appeared no matter time range...
Should this be possible? my idea was to use such a thing in Goal or metric of TSVB.
When searching in web i found answers like created a scripted field or a having that information in input like new field with True/False.