topic Overlap of Data in Dashboards & Analytics Discussions

Overlap of Data

Spd_03 — Tue, 23 May 2023 10:10:33 GMT

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.

Re: Overlap of Data

RADSr — Tue, 23 May 2023 15:58:30 GMT

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

Re: Overlap of Data

Spd_03 — Tue, 30 May 2023 08:55:43 GMT

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.

Re: Overlap of Data

Prince — Tue, 30 May 2023 09:53:43 GMT

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.

Re: Overlap of Data

RADSr — Tue, 30 May 2023 12:43:30 GMT

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 ).

Set up your groups and measure(s) so that things are aggregating correctly absent the country and location prompts.
Drag "person name" into measures again - as many times as there are candidate countries
Open the measure properties and drag a new formula to the "filter by" drop zone
New formula can be something like: country_name = 'Canada' but it's a formula so it can be as robust as you'd like ( ** almost - no summary filtering here )
Rename the column "Name Count: Canada" or the like.

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.

Re: Overlap of Data

Spd_03 — Wed, 31 May 2023 10:23:49 GMT

Here I want get the overlap of Person_name based on Job_Title and Age for the selected Country and Location.

Above data sample created for understanding but I'm using similar case study for getting the overlap.

Thank you