Animation Help

[#1]

Hello,

Can someone help me with animation? 

In this QVW, I am trying to animate by date, and show the top 10 Destinations (full accumulation).

Chart "Original Animation - not running"

* Not sure why this one is not running

Chart "Animation running, but aggregate total incorrect"

* As you can see from the data grid, each day, boston should be adding 18+11+10... etc

* When the animation runs, every destinations go to the same accumulation total.  Any reason why?

Chart "test one dest - not working"

* I try to filter just on Boston, but doesn't seem like accumulation is working correctly.

* Also, not sure how to get rid of the other "NULL total" bucket

Chart "How To Get Rid Of NULL Destination" (non-animation)

* Like previous report, how to get rid of the last "NULL" bucket

I've attached the report.  Let me know if anyone could help me clean up a bit.

Much Appreciated!

[#2]

Hi,

When i tried so select all the possible Hotels except for null values then the animation is working. Problem is that calculated dimension. What I recommend is get the another table with hotel description and rank (from SQL query its easy). In your expression add one more set analysis on rank like rank={"<11"}. This would solve your animation problem.

Full accumulation will accumulate for all dimensions. Hence all dimensions will show the same values as it data progress. To avoid this, you can create a cummulative sum at script level (or SQL) and write your expression on this.

Regards,

Kiran.