Row Limit in Bar Chart

micheleb

Hi,

I have built a bar chart that counts the number of completed cards by Card Title.

I limited the bar chart to return 25 rows. However, the results are not correct. Some of the cards have 1 completion are showing in the top 25 when there are 100's of cards that have more than 1 completion.

How do i accurately get the 25 cards with the highest number of completions and not the first 25 cards that appear in the dataset?

GrantSmith

Hi @micheleb

Are you sorting your results on your card based on the the aggregated / SUM of your values?

MarkSnodgrass

Agree with @GrantSmith Your sorting and limit properties should look something like this:

micheleb

thank you