Business Analytics

Expand all | Collapse all

Grouping dates not working

  • 1.  Grouping dates not working

    Posted 15 days ago

    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 11 days ago
    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
    ------------------------------