COUNT(DISTINCT *) desconsidering only one filter
Hi, People! I'm here again! The DOMO noob! 😊
I'm stuck with the beastmode problem:
Imagine that i have 4 cities e each one of it has a N number of reseller points.
In my table, i need to show that N number of reseller points considering all the filters of the page (globals and selections in cards) into one column and in another column, i need to show the [Absolute Number Of Reseller Points] that considers all the filters, except one.
That's what i have till now:
[N number of reseller points considering all the filters] = "Posit. At"
[considers all the filters, except one] = "Posit. Abs"
In the image above, i didn't use the filter, so the both column has the same value, OK.
Now, the problem:
In the image above, i used the filter, so the [Posit. At] has the correct value and the [Posit. Abs] should have 7.130.
That's the script of [Posit. Abs]:
"AVG(COUNT(DISTINCT `RETAILER_CODE`)) OVER (PARTITION BY `CITY_NAME`)"
Any ideas to help this noob? 😏