Is it possible to show the frequency of column in chart?

[#1]

hi,

I have a column CustomerID, name, date in table where CustomerID have duplicates. Can anyone suggest me is it possible to show the frequency of CustomerID in chart?

Thanks.

[#2]

Thanks. I tried this. This is not giving what I need. Any solution please.

I want output should appear as below

CustomerID	name	date	Frequency
129870580	XX	11/03/2015   15:42:17	5
129870580	XX	09/03/2015   16:46:09	5
129870580	XX	11/03/2015   13:57:47	5
129870580	XX	11/03/2015   13:44:51	5
129870580	XX	09/03/2015   16:31:47	5
160642783	YY	10/03/2015   10:45:05	3
160642783	YY	10/03/2015   17:53:37	3
160642783	YY	06/03/2015   11:36:11	3
190526569	ZZ	09/03/2015   12:54:49	3
190526569	ZZ	09/03/2015   12:57:42	3
190526569	ZZ	09/03/2015   15:32:50	3

[buzzy996]

u have try with this,

=Aggr( Count( CustomerID),CustomerID,name) for frequency.

[giakoum]

See my post further above. It was just a correction. And when the exact requirement is not known, all options should be mentioned.

[sebastianlettner]

Hi,

use this Expression

Count(Total<CustomerID> CustomerID)

[Anonymous]

Hi Amelia2000 just remove date column from table as it is unique for each record

. Your solution will work .

Thanks

BKC

[aapurva09]

Hi Amelia,

Try this in the script and just use sum(Frequency) as  expression-

Table1:

Load CustomerID,

         name,

         Date

From Path;

Table2:

Load CustomerID,

         name AS name1,

        Count(CustomerID) AS Frequency,

Resident Table1

GROUP BY CustomerID, name;

Thanks,

Apurva