-
CSV file and counting Expression breaking
Hello all,
Need a little help on this one. I have a poll graph I am building and I am trying to make CSV file drive the animation. The data will needed to be changed regularly and by a person who is not AE savvy in the least, That is why I thought a Data driven Graphic would be great for this graphic.All was fine and dandy until I wanted the Percentage to count up to the desired number in the CSV file. I could not get the percentages to animate along the path of the bar graph or have the tally of votes animate along the bar as it went to the desired end point. I tried the slider expression and that works great if I wanted come into After Effects and change the values all the time.
I wanted to be able to update the CSV file and open up After effects and send it on its way. I ultimately would love to turn this thing into an essential graphic and have the person be able to work in premiere and send the project on its way and get it out of my hands all together but one step at a time. HAHA.
I have tried all kinds of counter expressions. I can not get the numbers to move along the path and count up while using a data from the CSV file in the graphic.
any help or ideas would be very helpful thank you for your time,
Thank you,
Matt
-
5 Replies
-
Hi, how are you animating the bars, are they just simple rectangle shape paths?
Your best option would be to go with the linear expression, like this
v=footage("data.csv").dataValue([0,0]);
s=thisComp.layer("shape 1").content("bar").content("bar").size[0];
linear(s,0,1000,0,v)+"%"
While the width of the bar reaches the value 1000, linear interpolates the corresponding percentage value. If you use a different method you could also linear along the time. Maybe you could show us how you animate the bar? -
Do you want the actual values to change during the animation, or only the position of the number, and the length of the bar ?
Are these percentages always integer numbers ?
Is there a fixed time when the grow should occur, or do you want to keyframe that ?
-
Hey Matthew, most likely you are not able to make values to change, because they are not defined in time.
Meaning, in order to make values animated, they should be mapped in a timeframe. Could you share a stripped down sample .csv, or even consolidated .aep alongside to help you directly? That just allows making suggestions a lot faster and more convenient !
Find out more:
Motion Graphics Design & After Effects Tutorials
On YT
On VH -
Thank you for chiming in. yes I would like to have the Percentage and the Votes Tally to go from zero to what is in the CSV file. this is the hard part for me to figure out.
Matthew Pugerude -
I a currently using a Stroke but if a rectangle shape would be easier I could easily do that.
Reply to this Discussion! Login or Sign Up