Replies posted by Jan
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
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?
Already have an account? Login
Login to the community
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.