*** Note, this is an information shared with whom it is interesting. Not a question, nor a request of help. ***
Hello,
thanks to the unvaluable Adam Stout's
https://www.servicenow.com/community/performance-analytics-blog/tracking-and-reporting-on-dashboard-...
I came up with a no code version, for people like me not very found of scripts, scheduled jobs and the like.
Actually, you end up with a much shorter, easy to exploit and maintain stuff.
To make it work, you create the table as explained by Adam Stout.
Then, instead of creating the script and schedule it, you create the flow as in the attached screenshot:
That’s it.
Of course you can run it selecting past records of Navigator History, to build some history.
Note:
- for the sake of shortness and simplicity, it is possible to avoid the nested Look up (Action 3), using some Regex in Transform Function in the Create Record action (action 6).
- I had to add the Update Record action (action 7) because for some reasons the “Created” was set to current execution of the Create record action, instead of the Navigator History Created value.
- with minimal changes to the conditions in the first Look Up (action 1), you can obtain the same results for Platform Analytics dashboards.
Hope it helps
Flavio
