Skip to main content
Question

Custom Chart - Rolling Relative Performance

  • April 12, 2017
  • 0 replies
  • 18 views
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
      This topic has been closed for replies.

      • MCFNeil
      • Quickbase Alumni
      • April 12, 2017
      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
      • Quickbase Alumni
      • April 12, 2017
      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
      Terms & ConditionsAccessibility statement