Join our Community in its new Home - The Datorama Trailblazer Community Group!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.
We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.
We can’t wait to see you there!
Interactive Date Filter for Date Attributes
CJedlicka
Manassas, VAACCOUNT_ADMIN 
I would like to add an interactive Date filter to a dashboard to enable the user to filter data on an attribute that happens to be a date type. The standard interactive Filter widget technically works, but it requires that you include/exclude each individual date, making it very tedious to apply a range of dates.
The interactive Date widget appears to have the option to change the target dimension from the default Main Entity's Date dimension to the target date attribute, but this solution doesn't appear to work properly and results in 'no data available' for any target visualizations.
As a use-case example, imagine an employee entity that had a standard Date defined containing the employee's start date, but also included a Termination Date attribute that included their last day as an employee. In this scenario, the dashboard should include employees that started this year, but filtered to only show those that were terminated this month. I'd like to use the page-level date filter set to YTD, but have an interactive Date filter that would apply to a table to limit the records that had a Termination Date within a period (this month). In the entity, the Termination Date is defined as an attribute of Date type.
If the interactive Date widget doesn't support this, it's not clear what the purpose would be of changing the dimension field within the interactive Date, or otherwise, how to filter attributes of date type. Can anyone help or offer some direction?
The interactive Date widget appears to have the option to change the target dimension from the default Main Entity's Date dimension to the target date attribute, but this solution doesn't appear to work properly and results in 'no data available' for any target visualizations.
As a use-case example, imagine an employee entity that had a standard Date defined containing the employee's start date, but also included a Termination Date attribute that included their last day as an employee. In this scenario, the dashboard should include employees that started this year, but filtered to only show those that were terminated this month. I'd like to use the page-level date filter set to YTD, but have an interactive Date filter that would apply to a table to limit the records that had a Termination Date within a period (this month). In the entity, the Termination Date is defined as an attribute of Date type.
If the interactive Date widget doesn't support this, it's not clear what the purpose would be of changing the dimension field within the interactive Date, or otherwise, how to filter attributes of date type. Can anyone help or offer some direction?
Comments
This did allow me to filter on a date range other than the native Date dimension, but it looks like we're still limited to a single date filter per page.