Date Filter Configuration

[JeremyHoffman]

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!

[Rampriya-S]

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 🙂

[JeremyHoffman]

Hi @Rampriya-S Thank you for the reply. I used the out of box indicator to build a list report using the same exact conditions and Related Table conditions (except for the week starts on). What I am looking to do is create a dashboard filter to allow the user to select a different range of dates to see those records. 
So, in other words, the report will not contain a filter for the Week starts on. Meaning it will only show users who never created a time sheet - in our environment we have 2 users (we went live back in June with timecards). What the ask is to have a Week starts on date filter so the leader can select a date or range and then see users who are missing time sheets for that week or range of weeks. Does this help provide clarity on my need?