New Topic

Community Topic Idea Chart Builder

Eric Hagfors

Yellowfin Support Team

Assigned

Category Chart Builder

Product Version 8.0

Chained filtering

Vefa Gulecyuz shared this idea ago

Idea Logged

Hi guys, I have a problem with filters. I will try to explain it through an example.

I have a sales report of different products. I filter the sales revenues based on some condition. (i.e. sales greater than 5,000). As a result, I see a subset of products having this condition.

As a next step, I would like to use this subset of products as a filter in another report. For example I would like to show another report (as a codisplay) which will be filtered according to the products of the previous report.

The problem, this subset of products is not filtered on products, but on another field (sales).

Do you think this is possible with current infrastructure? (Using values of a field as a filter in another report)

If not, can you develop it? :)

Regards

PS: Actually my current use case is with Top N Advanced function. I show products with top N values. I would like to use the products as filter in another report.

I like this idea 0

Replies (4)

Eric Hagfors ●

Hi Vefa,

Thanks for reaching out to support with your issue. I believe I was able to replicate this behavior with a simple Ski Team report -

Made a report with top n advanced function -

bb9b1d1685f143eefab3c654942431fe

Made a second report, linked to report 1 as a co-display -

10191d8fafb275c8ace6bbe4dfa5217e

Report Showed Top N on master report but not co-display -

94f9ef6c4a54f8992dd66c0924d377b7

As opposed to a regular user prompt filter, that passed to the co-display report -

ae3b3548e2ad8da638952ebdbdd176b3

Could you confirm this is what you are experiencing, as well as the desired outcome in this case? If so, i can create a task for developers to look into this functionality.

Thanks,

Eric

Reply URL

Vefa Gulecyuz ●

Hey Eric, this is the exact same situation that I am facing.

Thanks!

Reply URL

Eric Hagfors ●

Thanks for confirming, Vefa.

I've gone ahead and created a developer task to look into this possible software enhancement. As such, I will convert this public question to an Idea, and mark as Idea Logged. Updates to the task will be provided here as they are available. Feel welcome to "like" this idea for increased visibility, or reply here with further related inquiries.

Thanks,

Eric

Reply URL

Vefa Gulecyuz ●

Thanks Eric

Reply URL