Custom Chart - Rolling Relative Performance

Question

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-month performance? So on day 1 (e.g 1 Jan 2017) I would have sum of values from 1 Jan 2016 to 31 Dec 2016 divided by a constant, on day 2 I would have&nbsp;sum of values from 2 Jan 2016 to 01 Jan 2017 divided by the same constant etc. Thank you

mcfneil · Answer

It sounds like you are trying to make a report that gauges progress towards a goal.

have you used a gauge chart? Depending on how your app is built you should be able to do it with a gague chart...

Just an idea

_anomdiebolt_ · Answer

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

Forum Discussion

Custom Chart - Rolling Relative Performance

2 Replies

Related Content

Performing Multiplication in Jinja for Pipelines

Rolling 3 Month Average

Platform Performance Issues?

Performance Insights

Slow performance for 2 Days

Recent Discussions

Dashboard Variants

Pipeline API Post

Back to basics: Pulling info from a grand-parent table

File Attachment Field in Pipelines

Can I use quickbase actions within the same table?