To GoodData homepage

Replies posted by Jan

2 Replies

Jan
JanNew Participant
asked in Metrics and MAQL

metric not available

 It’s pretty simple:The “Typ” is either “issued” or “received”. The “Netto” is positive in the case of “issued” and negative in the case of “received”. Trying to build a simple metric, which will be positive for all records. What I tried so far:SELECT Sum(IF Typ = "issued" THEN Netto ELSE -Netto END) by Date (Datum)SELECT IF Typ = "issued" THEN Netto ELSE -Netto ENDSELECT Sum(IF Typ = "issued" THEN Netto ELSE -Netto END)SELECT IF Typ = "issued" THEN Sum(Netto) ELSE Sum(-Netto) END by Date (Datum)etc… Basically anything which “could” work, even some nonsense :)Thank you for your help!Jan

5
Jan Kos
GoodData Employee
2 years ago
Jan
JanNew Participant
asked in Metrics and MAQL

metric not available

Hi Jan, It depends how is your LDM build and how are your datasets connected. If your metric is build under certain dimension, objects which aren't related to this dimension disappear from the list of available objects. Feel free to check following community post as an example:   To get around this, “Explicit lifting” feature using BY clause can be used when building metric. BY keyword locks the aggregation level at an attribute that would otherwise not be able to slice a particular metric. More information information in the following article:https://help.gooddata.com/classic/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/explicit-lifting -Jan Thanks, tried to go through and apply some hints, but it didn’t help. Still the same behavior. One more thing I noticed - for facts, once dragged to Line chart metrics, the “Sum of “ that fact appears automatically, which is not the case for custom metric….Any more clues please?

5
Jan Kos
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings