Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have my date(DD-MM) i want to use in my bar chart, as you can see in the screen.
I would like to sort it.
Thanks in advance!
Hi
To get the right sorting order use dual() function
how did you create these dates?
Hello!
I wrote this Date(A,'DD-MMM'), where A is my date field.
Can you show me exactly how to do, plz?
after writing dual( month(A), day(A)), then???
Thanks in advance!
Hi
I assume your date format for field A is somethink like this by default DD-MM-YYYY
for example 05-01-2022
in your graph you writed as date dimension this
date(A,'DD-MMM') to get this date format 25-avr. ; 28-mai ; 16- juin etc
then without order parameter you get wrong order in X abscisse like that :
So if your field A for date is well recognise as an integer in format DD-MM-YYYY just select in order panel order by number :
You can also force the order with dual function like that :
dual(date(DATE_JOUR,'DD-MMMM'),num(DATE_JOUR))
for you :
dual(date(A,'DD-MMMM'),num(A))
add this mesure in the panel option under order // order by expression // ascending
regards
It doesnt work!
I did what you said and i got this below:
1.Date(A, 'DD-MMMM')
2.dual(Date(A, 'DD-MMMM'),Num(A)) in sorting by expression
Hi
What is your date format from field A ?
can you provide an exemple