Hi - my aim is to import numerical data from an API as a monthly time series.
In the browser I want to have a drop down element, which would allow the user to select the type of growth rate being displayed.
So for example, if they chose time series A and B, a further drop down will ask them whether they want to view those series as year on year growth rates or 6 month annualised growth rates.
I’ve set the data up as a list of numbers and a list of dates. I understand how to build a group focus for the dropdowns and workflows etc. Just not sure how I would be able to calculate the growth rates on the data.
Also, I am assuming the data needs to be a list for the chart to read it, not sure if that’s true or if there are any downsides of this when it comes to calculating growth rates.
Any help is much appreciated!
What do you mean by growth rate? Do you have an example of what you’re trying to accomplish?
Yes, you need a list of values for the x-axis and one for the y-axis
Hi Alex,
Thanks for your reply. To explain, my underlying data is the CPI data from the US. It is currently stored as a monthly series of the price level. I’d like to display the inflation rate as a year on year growth rate. This would require making a calculation like: (This month’s value / Value 12 months ago) - 1
So I just want to work out how to do that. I think I may need to use the javascript tool for this, but not sure exactly how.
It’s been a while since I’ve worked with charts. If I remember correctly, the charts I worked with in the past (chart js plugin??) allowed tooltips on hover. My guess is that you can add a dynamic expression here so that each tooltip will show the growth rate when hovered
Thanks again for your reply but I want to be able to display the actual growth rate.
Lets say in my database I have 10 years worth of data. How would I chart the year on year percent change of that data?
I think the answer lies in using javascript but I’m not sure.
