Forum Discussion
Jolyon
Helper III
Helper IIIhow 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...
An elegant solution is to create a date bin. You do this by
- Right click on data field (make sure it's a date type)
- Select 'New Group'
- Create Bins (could be more than one month if you wish)
- choose the new bin for your 'shared axis' in the Report View
- win
I have been struggling with this for a while and this is so easy. Isn't that always the way eh! Thanks very much.
It worked for me also what i have done is i have created the bin and then sorted the actual column by data-bin (which is created )
And remember to check that your date column is well based on "DATE" type otherwise it may not work
this worked for me
The solution is awsome. After so many solutions, sort by column etc, this works for me. But one thing I don't understand why we can not customize the Min value & Max value? Mine, it is auto set Min 1/1/2020 Max 31/12/2021, it is not quite right if I want the data before 1/1/2020?
