Expression error for Count

[Jacklin24]

I am plotting a line graph with dates on X axis and count of process_id as height where process_status=Completed
Help me form the expression. There are duplicate values which cannot be removed from table.

process_start_time	process_end_time	process_status	process_id
10 Jan 9:30	10 Jan 9:40 AM	Completed	1
10 Jan 9:30	10 Jan 9:40 AM	Completed	1
11 Jan 10:40 AM	11 Jan 10:45 AM	Failed	2
11 Jan 11:50 AM	11 Jan 8:15 PM	Completed	2
11 Jan 10:20 AM	11 Jan 10:30 AM	Completed	3

This table should show 1 count for 10 Jan and 2 counts for 11 Jan. 

[Oleg_Troyansky]

Hi Jacklin,

I'd use something like this:

count({<process_status={'Completed'}>} distinct process_id)

Use the rounded date of the process_end_time as your dimension:

date(floor(process_end_time))

Cheers,

[HirisH_V7]

You can use Count of Distinct as Oleg suggested .  Also,  you can do a Load distinct  for that table in script it self to avoid duplicates, if limited set of columns were being fetched into.