Subscribe Bookmark RSS Feed

How to script the min max first last values to display at y axis with values

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

I run the following report each day. the report is a cumulative average of Guest Satisfaction Index for a seasonal resort hotel. Despite the Season Start value will not change for 2015 (but will change next year) the Season Top value may change and Season last value is always changing, so i have to manually adjust the axis settings, coloring, line style, values etc each time i run this report

Is there a way to script this process so the result is as follow each time with the correct values, lines, axis settings (displaying the text and value)?

Season Start is the first value of the data set,

Season Top is the max value of the data set,

Season Actual is the last value of the data set.

Many thanks in advance for your support

9247_Cumulative Average GLOBAL REVIEW INDEX of YEAR 2015.png

1 REPLY
saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

anyone idea?