Thank you for replying, I truly appreciate it. I looked at the workbook and I think it is it not quite correct based on what my requirement. The workbook picks out and displays the top 4 (in the WB example) with the respective views (10, 8, 7, 9) in the example you provided.
However, what I was looking for is
Top 2 - 19 views ... in total by adding K1 views + K10 views
Top 4 - 34 views ... in total by summing the views for K1, K3, K4, K10
Top 6 - ... and so on
Then, ideally graph on a bar chart/line chart/etc the results of Top 2, Top 4, Top 6, etc.
Just to clarify.
You want two bars -
Articles that have the most through the 50th most views (top 50).
Articles that have the 51st through the 100th most views (51-100).
Or do you want that second bar to be the top 100, which would be counting 1-50 again?
Thanks for replying. Your suggestion actually is useful for a different view. However, what I would like to have is a graph of the running total - example below built in Excel. Basically Top 2 is the views for K1 & K10 summed. Top 4 is the views K1, K10, K3 & K4 summed and so forth.
In in my real world scenario, I would similarly sum the views of the top 50 articles (K1, K1501, K3, K4157, etc) together to get the totals views of all the Knowledge Articles. Top 100 would sum the total view of the Top 100 viewed articles which include the Top 50 referenced earlier. I will look at an earlier response as well. Thanks again for your help.
1 of 1 people found this helpful
IF RANK(SUM([Views])) <=2 THEN "Top 2"
ELSEIF RANK(SUM([Views])) <= 4 THEN "Top 4"
ELSEIF RANK(SUM([Views])) <= 6 THEN "Top 6"
ELSEIF RANK(SUM([Views])) <= 8 THEN "Top 8"
ELSE "Top 10"
Bring this calculated field to Columns
Bring [Views] to Rows
You should be good. I think the Rank calculation is ok.