What's new in Customer Journeys?

Connect and learn more! ×
Issue with month format to create Trend Analysis Report for Data Progression — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Issue with month format to create Trend Analysis Report for Data Progression

Received Response
46
Views
4
Comments
edited Jul 10, 2018 4:37AM in Reporting and Analytics for ERP 4 comments

Summary

Issue with month format to create Trend Analysis Report for Data Progression

Content

Hi All,

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!