Business Analytics

Expand all | Collapse all

Grouping dates not working

  • 1.  Grouping dates not working

    Posted Fri October 16, 2020 05:08 PM

    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

  • 2.  RE: Grouping dates not working

    Posted Tue October 20, 2020 10:30 AM
    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