Map Chart - Filtered Group

[NormanStanleyBadger]

Hi 😀,

I have set up a Map Chart to show the location points of all customers and it is working as expected.

I am now trying to set up another chart that only shows the location points of a specific group of customers based on a set analysis calculation, in this case, each customer that opened an account in the last 12 months but has not purchased anything. 

Is it possible to do this in a Map Chart ?

Thanks.

[daturpin]

A Map Chart will display data as specified, so the same chart can do both of these things.

For example, if you have "all customers" in a point layer on the map, and then use another table, chart, or expression to select a group of customers, it will now show what is selected.

Here is a map that I am using, with no filters:

And then the SAME map, after I select a group of points from another table:

[daturpin]

Now, if you want TWO charts, and you want the second chart to only show what you want, note that in the PROPERTIES bar for the map, in the point layer definition, both FIELD and LABEL are capable of taking expressions. Click the F expression button and enter in whatever code you need to show pre-filtered data, and it will do so.

[NormanStanleyBadger]

Hey 🖐, thanks for the taking the time to reply. It was the second solution I need, the filters required are not modelled in the data set I have access to but do not own.

Aggr(
{
<
PK_CUSTOMER = P({<[Customer Opened Date]={">$(=AddMonths($(vMaxDataDate),-12)) <=$(=Date($(vMaxDataDate)))"}>}),
[Customer ID] =  E({<[Sales Sold Date]={"<=$(=Date($(vMaxDataDate)))"}>})
>
}

MaxString(
{
<
PK_CUSTOMER = P({<[Customer Opened Date]={">$(=AddMonths($(vMaxDataDate),-12)) <=$(=Date($(vMaxDataDate)))"}>}),
[Customer ID] =  E({<[Sales Sold Date]={"<=$(=Date($(vMaxDataDate)))"}>}) 
>
}
[Customer Name])


,[Customer ID])

This is giving me what I need, but if you (or anybody) can suggest any improvements for best practice, please do.

👍