Hello GoodData team, I have a question about creating and debugging Metrics. For the context, the original datastore used is MongoDB collection. MongoDB collection has Amount and Currency fields. Using GoodData Dashboards > Insights > Table widget, I'm able to view Amount and Currency Attributes. That is, in a Table view, each row represents the expected data. The challenge: I'd like to SUM all attribute values and filter subset of data based on the criteria. I've used following query:

SELECT SUM(*Loan Amount*)

SELECT SUM(*Loan Amount*) WHERE *Loan Currency* = *USD*

However, it appears that filter with

WHERE Attribute = AttributeValue

is not taking effect. As a side note, please suggest what is the best channel to post these type of questions. @Bianca Moldovan

Hello Maris, if you are using the platform edition then this is the best channel to post your question. In regards to your maql statement, are you picking the attribute value from the dropdown list to the right of the metric editor:

@Joseph Heun just to be safe, yes - for query I'm selecting attribute values.

The LDM is the Logical Data Model. Would you be able to provide screenshots of your metric and the report, and details as to what values you are expecting to see vs. what you currently see?