Forum Discussion

Jolyon's avatar
Jolyon
Icon for Helper III rankHelper III
9 years ago

how to sort Date (MonthYear column)?

Hello, need urgent help of yours:   I have a column Date (e.g. 01.01.2016), then I added columns Month and Year and concatenated them to get the column MonthYear(e.g. January2016):     No...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

An elegant solution is to create a date bin. You do this by

 

  1. Right click on data field (make sure it's a date type)
  2. Select 'New Group'
  3. Create Bins (could be more than one month if you wish)
  4. choose the new bin for your 'shared axis' in the Report View
  5. win

Anonymous's avatar
Anonymous
Not applicable
7 years ago

And remember to check that your date column is well based on "DATE" type otherwise it may not work