Animated chart

[rodri_morales]

Hi everyone, I'm new in this, well this is my query: I have a bar char with calculated expression "=count(if(BillOperation=0, Bill_Number))" and other types changeing the values of BillOperation (the bill has 3 states: Precharge, Process, Paid). I want to know how to do to animate the chart, so when I click in a bar (that count the bills that are in precharge state for example) I want that the other charts o pivot table show me the "precharge bills" or the bills that have BillOperation=0.

[rodri_morales · Accepted solution]

I create in the scryp a new dimension:

if(BillOperacion=0, 'PreCharge', if(BillOperation>0 and PaidOperation=0, 'Process', if(PaidOperation>0, 'Paid'))) as DimBill

And I use it in the chart.