How to Allign A correct Month order In char view?
I have Column Month..
Value Is See Image(april,aug,feb...)
But In Chart view I want Correct order...
Please Any one Help Me....
Thanks For Advance
Solved! Go to Solution.
The way i think you should do is to create a VC to associate the month to it's number. I would use SWITCH function:
https://support.google.com/appsheet/answer/10107700?hl=en
SWITCH(
[Month],
"January", 1,
"February",2,
"March",3,
"April",4,
...(you know what i mean)
)
Now you have a column to ordinate, now you have to search how to order it on the chart view.
An alternative and equivalent smaller expression could be
CONCATENATE( MONTH([invoice_date]), "-",
TEXT([invoice_date], "MMMM")
)
Edit: Still smaller would be
TEXT([invoice_date], "M-MMMM")
The way i think you should do is to create a VC to associate the month to it's number. I would use SWITCH function:
https://support.google.com/appsheet/answer/10107700?hl=en
SWITCH(
[Month],
"January", 1,
"February",2,
"March",3,
"April",4,
...(you know what i mean)
)
Now you have a column to ordinate, now you have to search how to order it on the chart view.
Oh yes . I make Small Change...Its Working..
CONCATENATE( MONTH([invoice_date]), "-", SWITCH( MONTH([invoice_date]), 1, “January”, 2, “February”, 3, “March”, 4, “April”, 5, “May”, 6, “June”, 7, “July”, 8, “August”, 9, “September”, 10, “October”, 11, “November”, 12, “December”, “” ) )
An alternative and equivalent smaller expression could be
CONCATENATE( MONTH([invoice_date]), "-",
TEXT([invoice_date], "MMMM")
)
Edit: Still smaller would be
TEXT([invoice_date], "M-MMMM")
User | Count |
---|---|
40 | |
32 | |
30 | |
16 | |
16 |