Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I would like to show the number of filtered rows on my dashboard. Could you please help me with that?
Regards,
Ram
Hi,
HI,
Maybe:
Count({1} AnyField) : all your row
Count(AnyField): filtred by selection
Count({1-$} AnyField) : excluded
Thank you. In the formula below, when I use only the dimensions I have on filters, it shows a value more than the actual number of rows filtered.
Count(AnyField): filtred by selection
It could be because of the measures and when they are aggregated, the number of rows fetched will be less than the value populated by formula above. How do I include the measures in the formula above?
For eg. Lets say I want to find the total number of rows based on dimensions (Region, BusinessDate) and measures (Native Currenry, Local Currency). How do I do that?