Hi everyone, in my data table, I have a virtual column that converts dates to month values in Turkish. In the histogram order of months is alfabatically not by month, I used a number prefix the month name as a quick solution.
How can I view by month in the correct order without prefix numbers?
Thank you.
ifs(
MONTH([TARฤฐH])=1,โ1_Ocakโ,
MONTH([TARฤฐH])=2,โ2_ลubatโ,
MONTH([TARฤฐH])=3,โ3_Martโ,
MONTH([TARฤฐH])=4,โ4_Nisanโ,
MONTH([TARฤฐH])=5,โ5_Mayฤฑsโ,
MONTH([TARฤฐH])=6,โ6_Haziranโ,
MONTH([TARฤฐH])=7,โ7_Temmuzโ,
MONTH([TARฤฐH])=8,โ8_Aฤustosโ,
MONTH([TARฤฐH])=9,โ9_Eylรผlโ,
MONTH([TARฤฐH])=10,โ10_Ekimโ,
MONTH([TARฤฐH])=11,โ11_Kasฤฑmโ,
MONTH([TARฤฐH])=12,โ12_Aralฤฑkโ
)
Chiming in @JCadence
User | Count |
---|---|
14 | |
11 | |
9 | |
7 | |
4 |