Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a variable call Month and using
Apr, aug, Sep....as expression
but when I use bar chart to visual it
it sorting using Alphabetical order , as the attachment.
And try to explore the 'sorting' area. Seem no way to make it work.
Also attched the qvf file, in the 2nd app.
Thank you for any suggestions
Hi Celine,
Add this =date(date#(month,'MMM'),'MMM') at your scripting part or where you are using month, it will sort w.r.t month. Same I did in your attach application.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Rohit Kumar
Or make use of Month function in the outer function instead of date
=Month(Date#(month,'MMM'))
Hi, Rohit, hi Sunny,
Thank you so much.
and the same thing if I want to sort the 'date of the week'
Mon, Tue, Wen, Thu, Fri
How could I use this?
=date(date#(date,'MMM'),'MMM') (guessing)
And where could I learn more regarding this
Scripting sorting in general?
Regards,
Celine
I would suggest you to create day in the script like this and the sorting will be automatically taken care of
WeekDay(DateField) as WeekDay