Enable Drilldowns in Union Subqueries

Andrew Clauson shared this idea 3 years ago
Completed

This would be helpful, as it's unfortunate drilldowns get disabled when adding a subquery, especially when the master and subquery are drawn from the same view.

Replies (3)

photo
1

Hi Simon,

Below are screenshots of what I’m working with.

Each screenshot is from a separate report. Both reports do exactly the same thing and return the same results from the same view. The only difference is the one with the UNION returns a separate user-filterable subset of data from the view for comparison.

As you can see, drilldowns don’t work on the report with the UNION subquery. In fact, in the report builder under Analysis Style, “drilldown” isn’t available as an option.

Hopefully I haven’t missed anything in the setup. If this is indeed part of that known limitation with subqueries, yes, please add me to that enhancement request if I’m not already on it.

Thanks,

Andrew

ac5c931a12457780ebf8f85b11802951

5cb5326fbf2fd041711b48e4d64ba11f

From: Yellowfin Support <support@yellowfin.bi>

Date: Monday, May 31, 2021 at 6:42 PM

To: Andrew Clauson <andrew@profinancial.bc.ca>

Subject: New Comment in "Enable Drilldowns in Union Subqueries"

photo
1

Thanks, Simon.

From: Yellowfin Support <support@yellowfin.bi>

Date: Wednesday, June 2, 2021 at 7:30 PM

To: Andrew Clauson <andrew@profinancial.bc.ca>

Subject: New Comment in "Enable Drilldowns in Union Subqueries"

photo
1

Yes, let’s close please.

From: Yellowfin Support <support@yellowfin.bi>

Date: Wednesday, June 2, 2021 at 9:09 PM

To: Andrew Clauson <andrew@profinancial.bc.ca>

Subject: New Comment in "Enable Drilldowns in Union Subqueries"

Leave a Comment
 
Attach a file