Showing Top N by component

Questions & Answers
1

I have stats showing the amount of visits for pages on my website.

I have my rows set up by:

  • Time (quarter)
  • Webpages

I have a measure that shows me the amount of visits for my pages. When choosing to show Top N, it shows me the top 5 pages across all quarters.

I am trying to get a Top N for each quarter. How can this be done?

2

Hi,

The idea behind the solution is to implement a new custom measure giving the rank of each Webpage for each quarter. The formula would be the following:

CASE WHEN
[Measures].[Page visits]>0
THEN
Rank(
  [Webpages].CurrentMember,
  Order(
    Filter(
      [Webpages].[Webpages].Members,
      [Measures].[Page visits]>0
    ),
    [Measures].[Page visits],
    BDESC
  )
)
END

That gives one more column in our report:

image
image1136×1166 59.4 KB

Now we can apply filtering for having the top 5 pages in each quarter:
image
image1410×1332 113 KB

You can remove the measure from the report; the filter will persist.

Kindly,
Janis, eazyBI support

3

That’s great Janis - thanks!