Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I want to count the number of unique rows based on different attribute in the table,
Week Ending Date | Target | Build ID | Modem | L1 Test Status | L1 Test hrs | L1 Blocking Issues | |
96 | |||||||
2009-10-18 | 8650 WM 6.5 | AB1 | UMTS | L1 Pass | 24 | ||
2009-11-15 | 8650 WM 6.5 | AB2 | UMTS | L1 Pass | 24 | ||
2009-09-06 | 8650 WM 6.5 | AB3 | CDMA | L1 Pass | 24 | ||
2009-09-06 | 8650 WM 6.5 | AB4 | UMTS | L1 Pass | 24 | ||
so in this case based on the Week Ending Date],Target,Modem it should give me unique number of rows.
so for the above case for date 2009-06-09 the count should be 2 where as for the other 2 rows it should be 1-1.
I tried the aggr function but it seems to be giving me count as 1 for all the rows.
can someone please help.
Thanks,
Hi,
i think your Week Ending Date Format might be with timestamp thats why its not giving you count
Change Format OF Week Ending Date in to 'YYYY-MM-DD'.......