topic Re: Clustering / Aggregate a Count in a chart in App Development

Clustering / Aggregate a Count in a chart

Riccardo — Mon, 20 Dec 2021 21:08:46 GMT

Hello,

like the image, I have to do a count cluster:

# of Customer having a Sum(isVisit) = 1

# of Customer having a Sum(isVisit) = 2

# of Customer having a Sum(isVisit) >= 3

Do you know a best way to do it?

Thanks

Re: Clustering / Aggregate a Count in a chart

Riccardo — Fri, 02 Oct 2020 11:08:32 GMT

Trying this, it works. But I'm not sure that is the best way:

DIM

=if(aggr(sum(isVisita),Customer) = 1,'1',
if(aggr(sum(isVisita),Customer) = 2,'2',
if(aggr(sum(isVisita),Customer) >=3,'3+')))

Measure:

sum(isVisita)

Re: Clustering / Aggregate a Count in a chart

Kushal_Chawda — Fri, 02 Oct 2020 11:08:54 GMT

@Riccardo try below

Dimension:

=valuelist('1 Visit','2 Visit','3+ Visit')

Expression:

=Pick(match(valuelist('1 Visit','2 Visit','3+ Visit'),'1 Visit','2 Visit','3+ Visit'),

Count({<CustomerID ={"=sum(isVisit)=1"}>} distinct CustomerID),

Count({<CustomerID ={"=sum(isVisit)=2"}>} distinct CustomerID),

Count({<CustomerID ={"=sum(isVisit)>=3"}>} distinct CustomerID))

Re: Clustering / Aggregate a Count in a chart

Kushal_Chawda — Fri, 02 Oct 2020 11:12:01 GMT

@Riccardo or below

Dimension:

=valuelist('1 Visit','2 Visit','3+ Visit')

Expression:

=Pick(match(valuelist('1 Visit','2 Visit','3+ Visit'),'1 Visit','2 Visit','3+ Visit'),

sum({<CustomerID ={"=sum(isVisit)=1"}>} isVisit),

sum({<CustomerID ={"=sum(isVisit)=2"}>} isVisit),

sum({<CustomerID ={"=sum(isVisit)>=3"}>} isVisit))

Re: Clustering / Aggregate a Count in a chart

MMS118 — Mon, 05 Oct 2020 12:56:11 GMT

Hi,

You can add a new dimension to your dashboard.

Perform the sum(isVisit) calculation on your load script as such.

TableName:

Load

AggregatingDimension,
IF(sum(isVisit)=1, 'isVisit=1', IF(sum(isVisit)=2, 'isVisit=2', 'isVisit=3')) as NewDimension

Resident OldTable
Group by AggregatingDimension;

Then you can simply have a bar chart with dimension = NewDimension and measure= count(Customer)

Re: Clustering / Aggregate a Count in a chart

Riccardo — Mon, 09 Nov 2020 17:27:13 GMT

Thank you. I'm using this solution, and it works fine.

Just a question. If I click the bar chart of "2 Visit", I would like to select (filter) the Custoemrs of cluster "2 Visit". How can I do that?

Thanks