Hello,
In my dashboard I have different visuals with different set of dates.
For example: on the top my KPIs are the last 2 years, a couple of visuals are last 13 months and an other group of visuals are the current month.
I have 2 different dataset both of them have the field date_month (YYYY/MM)
Except my date filter on the control area, i have 2 other filters (again parameters) string type both of them. Let’s say FilterA and FilterB. both of them are connecting with the same dataset
I am connecting these 2 filters with the relevant values option like FilterB relevant values only to FilterA.
What i need is sorting out the FilterB according to Date parameter, otherwise i got historical data in my dropdown. Is any way that i can do that? I tried to use the simple date filter but something like that is not working, according to my needs.
But, mainly i need to see how can i connect 2 parameters. one parameter is a date parameter and the other is a simple string dropdown parameter.
How can i connect these 2 for the moment the date parameter isn’t connect with a dataset?
Because of the above question, the string parameter presents historical data (3 years ago) that i don’t need them. how can i sort out these
1 Like
Hello @samytar97, so is the date filter not showing as an option within your Relevant Values selection? The filtering capabilities have updated recently, so I am thinking there should be a way to resolve this. Are you able to build a demo analysis of this in Arena? That would be the best way for me to assist you in fixing this issue.
The relevant values option will be the best way to ensure your dropdown is only returning the values available in that time period. With a little more information I can help guide you further. Thank you!
Yes adding the link below of the parameter
Test Dashboard
This particular dataset has data from 2020 to 2023 however lets say in the control if I select the date as Jan 1st 2024 to Today date still the list of customer drop down is visible. And as per the date set the customer list should not be present. So how do i ensure that based on the date selected there should be an cascading effect on the customer name also.
@DylanM
1 Like
Hello @samytar97, okay, I see the issue now. The filter would function a little differently, but if you utilize a Relative Date filter instead of the Between 2 dates filter, you can add it as a control and apply the Change Relevant Values to the Customer Name control.
Also, with the recent updates to filtering, you can apply the fitler across datasets if they have matching date fields. You can also apply it across sheets.
I will include screenshots below of how I built the relative date filter, and the control information. It is a bit of a work-around, but this should get you to your solution:
1 Like
