Dashboard to dynamically show the records that satisfy a condition based on a date/time type field.

[harishtheva]

Hi,

I have a requirement in which I need to create a dashboard in CSM Configurable Workspace which should show the requested item records that satisfy the condition: "If the current date/time upon the user is viewing the dashboard is within 24 hours of the date/time in a specific field" The field itself is a date/time type field.  Would this be possible and if so, if I can be provided the details on how this can be achieved. Thank you

[victoria88paul]

To create a dashboard in CSM Configurable Workspace that shows requested item records within 24 hours of the current date/time, you can set up a filter. Use a script to calculate the date range and apply it as a condition. For example, compare the date/time field with the current time and 24 hours ago. Add the filtered data source to your dashboard and configure widgets to display the records. This will help you visualize the requested items accurately within the specified timeframe.

[Dr Atul G- LNG]

Hi @harishtheva 

The dashboard itself doesn’t do anything on its own; it's the reports you add to the dashboard that provide the functionality. So, you need to include these conditions in your report, and it will work properly on the dashboard.