Solved

GoodData - fixed value over time

  • 26 August 2022
  • 1 reply
  • 35 views

Is it possible to carry one last value in time (T2) over to previous times? In Tableau I would use LOD "FIXED" expression..

I already tried all the PARENT filters WITH/WITHOUT EXCEPT.. Nothing works..


Input:

| Time | Value |
| -------- | -------------- |
| T-1    | 7            |
| T0   | 8            |
| T1   | 9            |
| T2   | 10            |

Wanted output:

| Time | Value | Result |
| -------- | -------------- | ------ |
| T-1    | 7            | 10 |
| T0   | 8            | 10 |
| T1   | 9            | 10 |
| T2   | 10            | 10 |

icon

Best answer by Jan Kos 26 August 2022, 17:23

View original

1 reply

Userlevel 2

Hi Roman,

If the last value you mean MAX value you can use BY ALL IN ALL OTHER DIMENSIONS to lock the aggregation level. Metric could look like this SELECT MAX(Value) BY ALL IN ALL OTHER DIMENSIONS.

-Jan

Reply