Count date

[#1]

I have Date column named newdate.

I want to create a new table which has two columns. a date column and count column which shows the count of each date.

For example 02/05/2016 will have count 1.

[Chanty4u]

create a stright table

with newdate dimension and add

expression as  count(distinct(newdate))

[Gysbert_Wassenaar]

Add a measure as second column. count(newdate) should work if newdate is not a key field linking two tables. Otherwise count another non-key field.

[HirisH_V7]

Hi ,

Is this,

[#5]

You can create a table:

dimension: newdate

expression: count(newdate)

Or create a list, showing frequency.

[mithilesh17]

Hi,

why you need another table???

simply use newdate as dimension and count(newdate) as expression on front-end in straight table.

Regards,

[#7]

newtab:

Load

        (newdate) as Dateee, 

        count([distinct] newdate) as c

RESIDENT root;

Is this right? It gives this error

The following error occurred:

Error in expression: ')' expected

[#8]

Hi,

How to do that? can you give me the script for it.

[#9]

even if first date is twice it is not showing as one. it is showing two different entries.

[#10]

It does not work. It gives frequency of every date as 1. where as we can see that the first date itself is repeated. It should have been clubbed and shown as frequency 2.