locked
Date Handling RRS feed

  • Question

  • I've got a local dataset with several date columns all in the format yyyy-mm-dd (plus the odd NULL). These don't seem to get handled very well on the x axis, the bins don't group them by date periods. It looks like it is treating them as text strings so the bin only contains rows for matching dates whereas I'd like them to be binned by date ranges. If I select 9 bins I get the first 8 bins with a couple of rows in each and an 'Other' bin with the remaining 18,000. 

    I've seen mention of using the data scrubber to fix the format but when I select the dropdown all I get as a choice is 'None'. Is there a date format that is recognised as such and generates the bins properly? 

     
    Tuesday, June 4, 2019 10:45 AM