Is it possible to link filters on a dashboard with a custom rule?

Renato Marcello dos Reis shared this idea 30 days ago
Idea Logged

Hi guys,

I was wondering if it may be possible to create two separate reports to add in a dashboard, with the same View, Fields and Filters. The only difference between then, is that the second report, must be based on the data filter selected on the first report minus 1 year.

In this example, we can see the results for the same period of time one one year ago side by side in a single dashboard.

I know we can achieve this using a simple sub query by adding a linked filter, but when we use sub queries, the drill through does not work as said in a previous topic.

https://community.yellowfinbi.com/topic/using-drill-anywhere-with-subqueries

Thanks in advance.

Regards,

Renato Marcello

Comments (2)

photo
1

Hi Renato,


Thanks for your interesting question.


Unfortunately, this is not possible, however, I would be happy to turn this into an Idea post, to be considered for an Enhancement Request. The ticket you have referenced is a feature called a Dynamic Filter and is not yet something that Yellowfin supports. I have added you to the Idea post here that is being considered for an Enhancement, where I will keep the post updated with any changes.


The only solution I can think of is to make a copy the original report, making a change so that the only difference is that the subquery filter is one year different. This creates another report that will need to be maintained and you won't be able to filter on the date (it will be hardcoded for those two years) so it's not a perfect solution, but it should get you the result you are looking for.


Kind regards,

Simon

photo
1

Hi Renato,


I'm just messaging to let you know that I've changed this to an Idea post to be considered as an Enhancement Request. Before becoming a request, ideas will be reviewed by our Product Team and chosen for Enhancements based on feasibility, level of positive impact to the user experience, and votes from the community.


I will update this post with any future information relevant to this process.


Kind regards,

Simon

photo
1

Hi Somon,

Thanks a lot for your help in this case.

I hope the developers can do this in a very short time, but I'll manage do try something else while I wait.

Regards,

Renato Marcello

photo