I am charting a data grouping (by date) with number values on the Y axis and dates on the X axis. I want to add a 2nd chart that will show the relative difference % from the starting point on the first chart.
So if the first chart data (that I’m pulling from my bubble database) is:
Jan 1
Feb 1.5
Mar 2
The second chart would show:
Jan 0%
Feb 50%
Mar 100%
This is stock market data and the user can change the starting and end dates for the data to be displayed on the first chart, so the “relative to anchor point” denominator is dynamic (which is why I’m not just creating another data type calculating the difference) so need to be able to calculate these difference values on the fly.
I need help figuring out how to do this. Could List Item Expression help with this? If so, could you please help a non-technical person with the javascript?