To GoodData homepage

Topics started by romanzdk

2 Topics

romanzdk
romanzdkNew Participant
asked in Metrics and MAQL

Filter by date in MAQL while ignoring dashboard filter

What I would like to achieve:Select specific day (date) using dashboard filter and from this specific date take e.g. 55 days back and for this period compute e.g. sum of Sales.Is it possible to somehow achieve this? I defined currently selected date asSELECT MAX(Date (Date)) BY ALL OTHER WITHOUT PF EXCEPT Date (Date)and lagged Day asSELECT Selected day - 55 and the metric for the sum:SELECT SUM(Sales) WHERE Date (Date) > Lagged day and Date (Date) <= Selected day WITHOUT PF however this does not give any results. How to solve this, please?

3
Moises Morales
GoodData Employee
1 year ago
romanzdk
romanzdkNew Participant
asked in Metrics and MAQL

GoodData - fixed value over time

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 |

1
Jan Kos
GoodData Employee
1 year ago
Welcome to the GoodData Community!Cookie settings