Solved

Comparison of data in GD.CN

  • 18 March 2022
  • 1 reply
  • 61 views

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?

icon

Best answer by Moises Morales 22 March 2022, 14:19

View original

1 reply

Userlevel 2

At this moment I would recommend using existing running total functions. For example:

select RUNMAX(Metric) BY Month/Year ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING

This may return value of previous row of report sliced by month/year and this lets you skip months for which no value is returned by the “Metric”. 

Regarding your second part of the problem, it may be possible to work with time macros in the future, although we don’t have an ETA for this.

 

-Moises

Reply