Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Date grouping parameter problem in line graph — 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

Date grouping parameter problem in line graph

Accepted answer
11
Views
4
Comments
edited Oct 30, 2019 8:56PM in Reporting & Analytics for B2C Service 4 comments

Summary

If I select "Month" as the grouping parameter my line graph shows 0 for months that are outside of the date_range filter

Content

Hi everyone,

I am attempting to copy report ID#85 Incident Trend and change it to a line graph.

Everything seems to be working well except for 1 issue.

If I select "Month" as the date grouping I get the intervals 01, 02,03,...12 even though my date range filter is for incidents created in the last six months. The filter works, so for intervals 01, 02,03,04,11,12 the values are all 0. 

My question: How can I restrict the graph to only show non null intervals?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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