IBM Business Analytics

I am working on a dashboard in 11.1.4 and have a date field that I cannot group. The date field in question is an attribute and I have multiple data items associated with each date, so I want to group the dates and display a count of the data items on that date. 

What should I be doing to group the dates?

Thanks in advance!

------------------------------
Dave Chirayath
------------------------------

I dont play with Dashboards yet, but I have encountered similar issues where dates are stored as attributes instead of dates the application can recognize and chop up into months, years, etc. like an Excel pivot table does. This may sound overly simple, but worth a try... what about casting the underlying field in your source data as a date? It would be CAST(YOURFIEILD,DATE). Sometimes the attribute is stored in a very funky format that doesnt easily convert to a date without some help. I've sometimes had to sub string specific day, month, year values out if weird strings and arrange then in a MM-DD-YY format before casting the overall expression as a date.

@

------------------------------
Logan Whitaker
------------------------------