I´m trying to build a metric like below: SELECT COUNT(CUSTOMER) WHERE DATE BETWEEN ADD_MONTHS(DATE,-6) AND DATE But it does not return a distinct value. Does anyone have any insight, please?

by "does not return a distinct value" you mean it is returning nothing or that it is returning some number but not what is expected? the DATEs in your metric are all the same date or are they different date dimensions? (I am not sure I understand this WHERE date BETWEEN date-6M AND date). Also are you using GoodData Platform or GoodData Cloud (or GoodData.CN), please?