Forum Discussion
Helper VCalculating Top N across columns
hi Clint
You can try this:
-In the visual level filters on the right side of your report as shown in the screesnhot below:
-in the BY Value , you can drag the Project field from your dataset and chnage it to count.
- Change pay plan field to your required field
Hope this helps!
ClintHello Anonymous ,
To clarify, I need to calculate the Top N across values in multiple columns, not just one. I have something like 7 columns representing various attributes and each row in the dataset is a project name. I need to find the Top N (3) of project name count from all 7 columns; meaning which three 3 columns have the highest number of projects associated to them.
- Clint
Hello Anonymous ,
Here is a dummy of what the table structure looks like (removing proprietary info)
Project Name Status Close Reason Micro Stage Gate Date Created Closure Date Variance Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9 Column10 Project 1 Open 1 1 1 1 1 1 project 2 In progress 1 1 1 1 Project 3 Closed 6/30/2019 1 1 1 1 1 Project 4 Open 1 1 1 1