Discussions

Expand all | Collapse all

Custom Chart - Rolling Relative Performance

  • 1.  Custom Chart - Rolling Relative Performance

    Posted 04-12-2017 12:19
    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


  • 2.  RE: Custom Chart - Rolling Relative Performance

    Top
    Contributor
    Posted 04-12-2017 16:19
    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


  • 3.  RE: Custom Chart - Rolling Relative Performance

    Top
    Contributor
    Posted 04-12-2017 18:35
    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">https://getsatisfaction.com/people/dandiebolt">https://getsatisfaction.com/people/dandiebolt