Custom Chart - Rolling Relative Performance

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
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 sum of values from 2 Jan 2016 to 01 Jan 2017 divided by the same constant etc. Thank you
Photo of Adriano Figueiredo

Adriano Figueiredo

  • 40 Points

Posted 2 years ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,478 Points 20k badge 2x thumb
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
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 27,694 Points 20k badge 2x thumb
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
(Edited)