Questions tagged [maql]

Multi-Dimension Analytical Query Language (MAQL) that is used to define metrics in the GoodData Portal

More details MAQL Reference Guide

4 questions
0
votes
1 answer

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…
romanzdk
  • 930
  • 11
  • 30
0
votes
2 answers

Conditional statement in metric don't work properly in Gooddata report

I have this metric: The first value right above the "if" statement should be considered just for dates after September 1st; The second value right above the "else" statement should be considered just for old dates (before September 1st). What…
0
votes
1 answer

How to list records with the "NOT IN" filter based in two atributes in GoodData

For example, I have these tables: __vendors___ _______sales_______ |V_Cod|Name | |S_Cod |Item |Price| |1 |Alan | |2 |apple |10 | |2 |Fred | |2 |sugar |5 | |3 |Alex | |3 |rice |9 | |4 |David | |3 …
0
votes
1 answer

MAQL - Select all records that enclose a list of dates

I'm a bit of a noob in MAQL so I would like to know if it is possible to do the following thing : I got a list of reservations with a Start Date and a End Date I would like to be able to compute a metric that would give me (for reservations that…
WNG
  • 3,705
  • 2
  • 22
  • 31