Thursday, August 23, 2012

Use of a report Limit

Question:

I have a report with several filters one of which is metric is not null. I am also applying a bottom 5 ranking metric on the report.Unfortunately one of the bottom 5 is one that is filtered out because of the first filter (it's null on a particular metric). This wouldn't be a problem but my bottom 5 filter only now shows 4 values. How do I make the report to filter out the null values and then apply the rank.

Solution

Move the Bottom 5 ranking filter from report filter to a report limit. A report Filter places a where clause in the query but a report limit places a having clause.


The report limit can be applied at Data->Report Data options->Report Limit.

No comments:

Post a Comment