Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
| Order | order date |
|---|---|
| 111 | 11/01/2012 |
| 111 | 11/02/2012 |
| 111 | 11/03/2012 |
| 111 | 11/04/2012 |
| 222 | 11/03/2012 |
| 222 | 11/09/2012 |
| 333 | 11/01/2012 |
| 333 | 11/06/2012 |
| 444 | 11/10/2012 |
| 444 | 11/13/2012 |
See attached qvw
Count(Distinct [order date])
this will give the distinct count of order date.
Thanks a ton Renjith , that helped.