More complicated scripting based on Time and Graphs?

More complicated scripting based on Time and Graphs?

Hello,

I just discovered the Creator section and I find it really magnificient.

I am considering creating an app that is unlike any that I have seen developed so far. I would like to make use of the graphs. I work with groups that I want to support with data that is taken from the forms they fill in.

For instance:

- So far today your average is 10 (on a ranking from 1 - 10)

- Here is your perforance today.

- You are less than your average for the past week.

- This is your progress over the past two weeks.

- This is how your are this week compared to last week.

I am not sure if this is possible and if so, how you would script it.

I was looking into formulas and I did not see anything in this area explained to this degree.

 

Any support is greatly appreciated.

 Andy