Cant sort by year and month

[Anonymous]

How can i sort my graph by Year/Month? sort by column issues if i dont sort by month.

sort should be jan 2020,feb 2020,dec 2029,nov 2019

[VasTg · Accepted solution]

@Anonymous 

Single month has multiple dates and it doesn't know which one to take.

Create a monthkey (202001,202002,202003 etc) and use that in SORTBY.

If it helps, mark it as a solution

Kudos are nice too

[VasTg · Accepted solution]

@Anonymous 

Single month has multiple dates and it doesn't know which one to take.

Create a monthkey (202001,202002,202003 etc) and use that in SORTBY.

If it helps, mark it as a solution

Kudos are nice too

[Anonymous · Accepted solution]

As you said ceated one more column and madde it wole number used that in sort by column, its resolved