I have am OLAP table containing cases with event time of activity X and Y and a date picker based on the activity X. When I select a time range from my date picker (i.e. 01-01-2023 to 10-01-2023 or 01-02-2023 to 28-02-2023) I would like to see only these cases for which event time of Y is within the chosen selection with result 'in scope' and 'out of scope'. I don't want to have a second date picker and have to choose the same date range manually.
Question
Select cases with activity event time within a time range chosen from date picker
+3Hello,
The date picker is only capable of filtering out everything not within those dates, so you would not be able to see any event times for activity Y as 'out of scope'. There is currently no way to assign the dates from a date picker to two variables. The only current solution would involve having 2 dropdowns each to pick a start date and end date and assigned those to variables which you can use in KPIs and Filters.
Would you mind sending us a screenshot of your current date picker setup?
Lastly, we will forward this product request to our product team and hopefully this will be available sometime in the future.
Thank you for your patience and flexibility,
DS Team
Hello,
The date picker is only capable of filtering out everything not within those dates, so you would not be able to see any event times for activity Y as 'out of scope'. There is currently no way to assign the dates from a date picker to two variables. The only current solution would involve having 2 dropdowns each to pick a start date and end date and assigned those to variables which you can use in KPIs and Filters.
Would you mind sending us a screenshot of your current date picker setup?
Lastly, we will forward this product request to our product team and hopefully this will be available sometime in the future.
Thank you for your patience and flexibility,
DS Team
Hello,
I am sorry, I don't have it anymore. I have rebuilt my dashboard and applied other solution.
+3Hello,
I am sorry, I don't have it anymore. I have rebuilt my dashboard and applied other solution.
Hi,
We apologize for the late response, thank you for letting us know. If you need anything else feel free to reach out.
Best,
DS Team
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.