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
ajsingh's avatar
ajsingh
Frequent Visitor
8 years ago

hey tringuyenminh92 you did a great gob in finding the trick for this common issue. Congratulations!!

I have a small issue, i did created similar kind of column and i did sorting also based on that column but my visuals are not getting sort, based on the new column rather i can't see any effect on my visuals.

If possible, post some sollution for it.

Thanks in advance.

tringuyenminh92's avatar
tringuyenminh92
Icon for Memorable Member rankMemorable Member
8 years ago

Hi ajsingh,

 

After setting up by "sort by column", in the top right of chart (icon: "..."), please choose sorting by the field MonthYear, then it will be sorted in chart.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks it worked for me.