hello.
I am curious if there is a limit to how many results an Animation will return.
i have a report built that pulls up sales data for my users, and I added an animation that lets them select a client from the dropdown and show just their data. It's great, but it seems to not show all the clients. Is there a limit to how many it can return? Can that be changed? thanks!
Hi Tom,
I asked development to take a look into whether there's a limit to the animation, and whether that can be changed.
Hi Tom,
Got a response -- the truncation isn't actually coming from the animation, it's the pivot itself that is getting truncated.
The way the animation works is that it runs the pivot first, and then groups the results based on the animation.
If, without the animation, the pivot would be truncated (there's a message at the bottom that says if the report has been truncated), then the animation options will only be available for the results in the pivot before it's truncated.
However, if instead of using the animation, you create a dashboard and add a slicer, the slicer will be evaluated before the pivot, so there won't be truncation.
Let me know if that's clear, and if that helps resolve your issue.
