Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear community,
I hope someone can help me since this is driving me crazy.
I have a simple table with all the fields of the model which are 9. After some date filters, only one row show up in the table but my kpi shows '2' as value.
My script is:
I would appreciate some help please!
Thank you in advance
The table only displays unique combination of fields listed in it. That doesn't imply that Count() would equal = 1... When you see a count = 2, it means that there are two rows where the listed dimensions appear twice. Count(DISTINCT...) will give you 1
The table only displays unique combination of fields listed in it. That doesn't imply that Count() would equal = 1... When you see a count = 2, it means that there are two rows where the listed dimensions appear twice. Count(DISTINCT...) will give you 1
Thanks for your quick reply. I get your point! I understand now!