How do I remove the "Warning: Not All the Data is Shown" from a filter?

moneyshot

I'm adding a filter to categorize our sales into 3 groups. I get this message no matter what settings/chart types I try. Screenshots show all-time for the date field, but when I tried to do the bare minimum needed for the page it's on (one year) I still get the message.

How do I remove this? Any workarounds or alternatives?

Thanks as always for any help.

moneyshot

Adding a sort and count aggregation seems to have removed the issue.

Side note: not being able to remove your own posts is a real bummer.

moneyshot

Adding a sort and count aggregation seems to have removed the issue.

Side note: not being able to remove your own posts is a real bummer.

MarkSnodgrass

Yes, I often add the same field into the optional group by and choose to count.

You can accept your answer so that people know it is not an outstanding question and it will help others that run into the same issue.

HowDoIDomo

Moneyshot, not being able to delete your thread isn't a bummer at all. I had the same issue and found the solution thanks to you!

dle

I put 100000 in Limit Rows, and the problem goes away.

TejalGovila

@Moneyshot - In case of Donut chart I am unable to remove that warning even after applying the sort.

Mansa_TCC

Thank you!