Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

TOP 2 Users By Report

I have log of report users.  Each time a user runs a report, a log entry of the report name, their username and date/time they accessed the report are recorded in a log.  From that log I need to know...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Here's the solution.  I had to pick another column:

     

     

    And then I added the column and a page filter.  I selected the top 2.   That worked.

     

     

    Thank you for your help.  You steered me in the right direction.

     

    ---MW

VahidDM's avatar
VahidDM
Icon for Super User rankSuper User
4 years ago

Anonymous 

 

Add a new column with this code:

Rank = 
RANKX(filter(all('Table'),'Table'[Name]=earlier('Table'[Name])),'Table'[ReportViews],,DESC,DENSE)

 

Output:

 

 

then create a visual and add the new column (Rank) to the filter pane for that visual and set to show the 1 and 2.

Out put:

 

 

Download the file: https://gofile.io/d/TOkKKD

 

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

 

 

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Here's the solution.  I had to pick another column:

 

 

And then I added the column and a page filter.  I selected the top 2.   That worked.

 

 

Thank you for your help.  You steered me in the right direction.

 

---MW