I’m looking to graph a specific type of event log to get an idea of how many shot tasks our team reviews daily. But there is no option to graph Event Logs. Many other entity types can be made into a graph but not events.
A graph for event logs could be a powerful way to visualize how many shots are approved daily or reviewed daily with the correct filters.
This far I’ve managed to get the information as a list. Grouping the events per week, but I would love to be able to graph this.
I know there’s also a status history graph, but this is not giving me the information I want. For example, I want to know how many tasks change from “Rev” status to another status. Or how many are approved daily or weekly.
I don’t think there are enough efficient filter options within the event logs to have the graph widgets handle them.
Also relying on history events to track daily/weekly counts would give some inaccurate values. I understand the theory behind the idea but in practice there usually is too much randomness with how users interact with the database
Closest I’ve come is using the API to populate timestamps on the task level, which I can then graph.
Was something approved? It’s timestamped with the date, and I can now toss it into the graph. might not give me absolutely everything, but it’s been working for us so far.
We haven’t done this ourselves, but I could see using the API to populate date tags a multi-entity field whenever a task hits a specific status. So , you’d have an approval column, a revision column, etc… that accrues new date tags as the statuses change.
Buuuut, you’d have a whole mess of tags at that point, which may not be ideal
