Hello,
I am building a simple list visualization (The requirement is to show users who are missing a time sheet for any given week) on a Platform Analytics Dashboard. This list is built off of the User table (sys_user) with 2 conditions (Active is true and Roles is timecard_user), and 1 Related list condition -> Equal to 0 selected table record(s) are related to a record on Time Sheet-->User.
I have 2 filters that work. One filters by User and the other by the User's Manager. Both of these are built using the User table (sys_user).
This issue I am having is building a Date filter for "Week Starts on" which is on the time_sheet table. I am not finding a way to link it back to the user table. I have tried setting the "Apply to hierarchy" to true and false to no avail.
Is this even possible? If so, any insight or suggestions would be greatly appreciated.
Thank you in advance!
Hi @JeremyHoffman,
I see that there are out-of-the-box indicators already available in the system. You can take advantage of those, or you can create a new one based on your requirements. I’ve added screenshots that walk through how to build the visualization step by step.
Hope this helps — please mark it as Helpful if it solved your question 🙂
