Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In this chart, dimension=Month (fieldname=Monthname) and measure=Quantity.
Under sorting what would be the expression (formula)? Tried several formulas, cant seem to manage..
Thanks
Hi,
Is "month" the original data you get? If no, and if you have Date column in your original data, always better to get month column using "MasterCalender" script by using the Date (you can find a lot in the community). If "month" is the original info you get, then it is still string/text, can not be recognized as month in QV, that is why it can not be sorted correctly. You need first change it to a real month be recognized by QV. The expression for this is:
Month(Date#(Monthstring, 'MMMM')),
then it can be ordered correctly by using the setting in Sort tab is the chart properties.
And pls notice one trick when using this way, by default, the Month() method only recognizes the month name in the language you select for your QV.
Hope this helps.
Zhihong