Count number of duplicate and where they visited?

[#1]

Hi All,

I would like to seek your advise on the script (please paste here as I am using the personal edition). Thank in advance.

I have a very long list will be only showing a subset over here in table 1 and the answer I am looking at is:

           ANSWER

Row Labels	Shop	Leisure	Drink	Play	Fun	Eat	NO of events
A	3			1			4
B		3			1		4
C			3			1	4
D					2		2
E				2			2
F						2	2
G	1						1

Table 1   

Customers	Place of visit
A	Shop
B	Leisure
C	Drink
E	Play
D	Fun
F	Eat
A	Shop
B	Leisure
C	Drink
E	Play
D	Fun
F	Eat
A	Shop
B	Leisure
C	Drink
A	Play
B	Fun
C	Eat
G	Shop

[sunny_talwar]

Like this?

Pivot Table

Dimensions

Customers

Place of visit -> Enable Partial Sum on the presentation tab for this dimension

Expression

Count(Customers)

[#3]

I wasn't able to do a sort based on descending order on the column "TOTAL". how to do that?

Also If I want to tabulate the column "TOTAL" into a bar chart like number of time the '1' appear, number of time the '2' appear and so on.

For your kind advise.

[sunny_talwar]

A bar chart like this?

Calculated dimension

=Aggr(Count(Customers), Customers)

Expression:

Count(Customers)

For sorting I will have to play around with the data a little. Would you be able to  try this sorting expression (and uncheck all other options)

=Aggr(Count(TOTAL <Customers> Customers), Customers, [Place of visit])

also make sure the order is descending

[#5]

for the bar chart, how can I exclude "1" and only show the rest?

[#6]

for your advise,pls

[#7]

for the bar chart, how can I exclude "1" and only show the rest?

[sunny_talwar]

Use this expression:

If(Count(Customer) > 1, Count(Customer))

[#9]

Hi Sunny,

I used this expression If(Count(Customer) > 1, Count(Customer)) instead of the earlier Count (Customer), but I wasn't able to exclude the bar chart with 1 count.

Can you please assist?

[dinuwanbr]

Hi,

PFA

Rgds,

Dinu1