05-23-2023 03:10 AM
Hi All,
I want to calculate the overlap of specific column which may occur in multiple places.
Consider Person_Name as a column and I want to know in which location and country this Person_Name will occur and get the count of it.
I'm trying to achieve this under table visualization.
05-23-2023 08:58 AM
This sounds like a simple group by - group by country and person name and put person name in the measures with an aggregate behavior of COUNT
05-30-2023 01:55 AM
Hi @RADSr,
Thank you for your reply!
In my case I want to keep Country and Location as Prompts but not as a part of any columns in group by or measures. In that case how can I get the count of the Person_Name based on other grouping dimensions.
05-30-2023 02:53 AM
In that case, you might need to materialize the count group-by in an Analyzer View or Dashboard insight result set, then use that materialized result win your insight.
05-30-2023 05:43 AM
In that case you might want to use another feature ( I like it, I've mentioned it several times in Community so I hope I'm not too redundant ).
This is a bit of a grind, but I'm having trouble envisioning how else you'd display counts by country without having country as part of the report display ( rows or columns ).
If I'm still not getting it maybe post a sample wireframe or Excel example, but it certainly sounds doable.