We are facing an issue with GD.CN. Our clients need to be able to compare the results of individual generations of data with each other. In order to do that you have the FOR PREVIOUS function is used to create metrics. However, the problem occurs when the data is generated irregularly (for example, once every four days, once every two days, or vice versa five times a day - the spacing is never given). The function cannot take this into account, and in addition the second input argument of the function cannot even work with facts (this also includes the possibility to send information about the spacing between generations from the database to the dataset).
Unfortunately, we have not been able to find any other function or way to prove this - how to compare the data of the last generation with its previous generation if the spacing between the generations is irregular?
The second part of the problem is the question of whether it is possible to work with smaller time units in GD and display graphs at a level smaller than days - at the level of hours?
Best answer by Moises MoralesView original