Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to sort the date field in x-axis for my bar chart in chronological order (Jan, Feb, Mar....).
Should be represented as : 2021-Sep-13_A(Mon), 2021-Oct-21_B(Thu)
I tried doing like this in expression :
year(date(date#(left(date,18),'YYYYMMDD'))) & '-' & month((date(date#(left(date,18),'YYYYMMDD'))) & '-' & date((date(date#(left(date,18),'YYYYMMDD'))) & '_' & ('A' or 'B') & '(' & day((date(date#(left(date,18),'YYYYMMDD'))) & ')'
how could I solve this?
Use Dual function
Dual(
//Text Part
Date(Date#(Left(date, 18),'YYYYMMDD'), 'YYYY-MMM-DD') & '_' & ('A' or 'B') & '(' & Day(Date#(Left(date, 18),'YYYYMMDD')) & ')',
//Number Part
Date#(Left(date, 18), 'YYYYMMDD')
)
Use Dual function
Dual(
//Text Part
Date(Date#(Left(date, 18),'YYYYMMDD'), 'YYYY-MMM-DD') & '_' & ('A' or 'B') & '(' & Day(Date#(Left(date, 18),'YYYYMMDD')) & ')',
//Number Part
Date#(Left(date, 18), 'YYYYMMDD')
)