Amount growth loop

[former_member217085]

I would like to create a visualization where I click on the play button and a certain amount starts growing at a certain rate. Say the amount is 10,000 and when I hit the play button this amount starts growing at a rate of say 100.always in a loop continuing growing. Is this possible?

Thanks

[former_member182541]

Did you tried with play control component ?

play control.txt.zip

[former_member217085]

Yes. I think however that I have not explained myself correctly. What I am looking for is to have increments with no limits. For example, suppose i want to create a visualization that includes a ticking clock showing the federal debt increasing at say, $20,000 per second.

I such thing possible?

Thanks

[Former Member]

you can acheive it by using play control component.

Cell A1 is your increment value. Here For Eg, I have given a constant value. you can dynamically get the value.

formula in B2: B3*A1

Destination cell is the destination for play control.

[former_member217085]

Hi! Iswarya,

this is shaping up as a brilliant solution.... However, if I understand correctly, the scale limit would be the maximum number the value can take. Is there a way to solve this, apart of setting a very high figure and changing it ocassionally?

Thanks.

[Former Member]

Hi,

Try mapping it to E3 and check.