Troubleshooting
Problem
Resolving The Problem
running-count([data item to limit])
If there are multiple sets of data being ranked, the running-count needs to reflect that instead:
running-count([data item] for [grouping data item])
2) Add a filter to the query:
[running count data item] <= 10
Alternate solution:
1) In Query 1, add every data item you want in the list report
2) In the same query, create the query calculation rank.
rank([dataitem] for report)
3) Go to the Query explorer and click Queries.
4) Drag in a new Query (Query 2)
5) Drag Query 1 to the right side of Query 2 (so that a subquery is created)
6) Click Query 2.
7) Drag in every data item from the Query1 to Query 2.
8) Add a new filter in Query2. (click the Query Items tab, drag in rank and [rank] <=N)
9) Go to the page, select the list, change the query from Query 1 to Query 2.
The list now shows the first N items in the list ranked based on the [data item].
Was this topic helpful?
Document Information
Modified date:
27 August 2020
UID
swg21341684