Hello Joao -- You may be able to accomplish this with some IIF or IF statements. Do you have a sample of your data that you can share to test out?
Possible equation: IIF([Dimension1]='sample',COUNTD(ID),0)
OR you can build a traditional IF statement
Hope that helps a little!
Hi April, thanks for the response.
I Actually meant tables when I said dimensions, my bad. I have to get the number of visitors on each page from different tables. Unfortunately, I can't link the dataset here, but it is structured like this:
- There is a different table for each page on the proccess.
- In each of this tables we have one line for each user.
- The only measure I'm interested in is the COUNTD([user_ids]) on each table.
I ended up solving my problem using custom SQL to aggregate the counts in a same table but I was wondering if I could do this on tableau as it will be usefull for other analysis.
Thanks a lot anyway