Custom Chart - Rolling Relative Performance
Is there a way to create a chart where on the X-axis I have day of year (from 1 to 365) and on the Y-axis I have the sum of the previous 365 days of values in a time series divided by expected 12-mont...
Forum Discussion
You have to use script. See this demo which redraws a QuickBase rendered chart to use cumulative data:
Convert Chart to Cumulative Values On Y-Axis
https://haversineconsulting.quickbase.com/db/bk89redf6?a=td
What Chart Enhancements Do You Need?
https://community.quickbase.com/quickbase/topics/what-chart-enhancements-do-you-need
Fee free to contact me off-world using the information in my profile if you need assistance using this technique:
https://getsatisfaction.com/people/dandiebolt
Convert Chart to Cumulative Values On Y-Axis
https://haversineconsulting.quickbase.com/db/bk89redf6?a=td
What Chart Enhancements Do You Need?
https://community.quickbase.com/quickbase/topics/what-chart-enhancements-do-you-need
Fee free to contact me off-world using the information in my profile if you need assistance using this technique:
https://getsatisfaction.com/people/dandiebolt