Plot of rolling calculation
I'm fresh into Domo and but have reached my limit with a rather interesting request.
I have created a card that ranks the top 60 performing days out of the previous 120 days.
However, it only does this for the current day. In the attached graph the number I'm interested in is the 388. That's "Today's number"
For any day I would like to take the minimum of the top 60 days (out of previous 120) and then plot that value over time.
So for a given date Domo would calculate the top 60 best performing days out of the previous 120. Then take the _minimum_ best forming day (ie the lowest value in the top 60) and the score of that day that would become the score for the original day of the calculation.
In a related question - I think if I can see the code for the the current chart that will be a big step towards creating the code that I want. (Ie I sometimes work better in code than GUI) Is there any way to see the code that was generated for a card? Then I can use that as a starting point.
Thanks in advance!