a few other variants that I found in this forum, but none of them seems to work so far.
Q1: Could anyone please help me with how to create a new field/metric that shows distinct count of brands for each advertiser in every country?
Q2: Assuming I get Q1 resolved, I'd like to embed the number of disctinct count in the tree map (as shown in the screenshot example below/attached). Is that possible and if so, how do I customize/modify the tree map to make DISCTINCT COUNT appear along with other metrics?
Example Tree Map that I''d like to build
I'm also attaching the test data in CSV format below in case someone would like ot test it out. Country,Advertiser,Brand,Spend C1,A1,B1,10 C1,A1,B2,5 C1,A2,B3,0 C1,A2,B4,20 C2,A1,B1,8 C2,A1,B5,7 C2,A2,B6,4 C2,A2,B3,3 C2,A2,B7,2 C2,A3,B8,9
Thank you in advance for your suggestions/answers!