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.

[giakoum]

count(CustomerID)

or

count(distince CustomerID)

depending on requirement

[#3]

below is sample data

129870580
129870580
129870580
190526569
190526569
160642783
160642783
129870580
190526569
129870580
160642783

[aapurva09]

Hi,

Count(CustomerID)  in the expression and CustomerID as dimension will give you CustomerID wise frequency of that CustomerID.

Hope it wil help.

Thanks,

Apurva

[giakoum]

sorry this is the correct one :

count(distinct CustomerID)

[aapurva09]

Hi,

Distinct can not be useful here as it will count as 1 per CustomerID.

Thanks,

Apurva

[#7]

Thanks. I just want to know how many times it exists. like we have in list box there is an option check box Frequency.

I know I can get from list box. But I need columns CustomerID, name, date appear in table showing frequency of CustomerID

[giakoum]

then create an expression with count(CustomerID)

otherwise share a sample app

[aapurva09]

Hi Amelia,

Follow these steps:

1. Create a Pivot or a Straight table.
2. Set Dimension as CustomerID, name, date.
3. Expression as =count(CustomerID)

Now you will get CustomerID, name, date wise Frequency of CustomerID.

If you take pivot table, you can check the frequency at all 3 dimensions by Collapsing and Expanding those dimentions.

Thanks,

Apurva

[#10]

here is the data

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