I have a requirement to get a count of flag in my fact table. I can get a correct count in the database using this code (
SELECT distinct A_FLAG,
Number FROM B_FACT
where Number =12345
)
however when I try in this in the analysis (count(distinct "Fact - A_FLAG" by "Number ") ) and filter by Number =12345 I am not getting the correct counts . my question is if there is a way to write the code that I am running in the database in rpd or simply what would be the best approach?
