Issue with month format to create Trend Analysis Report for Data Progression
SummaryIssue with month format to create Trend Analysis Report for Data Progression
We would like to create a dashboard to show data volume progression by month ie volume trend analysis of invoices created for last 6 months. For this we are trying to pull creation_date from ap_invoices_all table and try to format it to 'MON-YYYY'. But when we create the graph report for this, it displays the months either in alphabetical order ie starting with APR-17, APR-18, DEC-17, FEB-17 etc.. This graph does not really convey volume of transactions created over a period of time. We tried formatting it as 'MM-YYYY'. Still display shows 01/2017, 01/2018, 02/2017 etc. Any ideas?