Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Is there an option in OAC [Visualize Data] to get the filter value inside my calculation? — 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

Is there an option in OAC [Visualize Data] to get the filter value inside my calculation?

Received Response
31
Views
1
Comments
edited Oct 18, 2022 7:46AM in Oracle Analytics 1 comment

Summary:

Is there any option to use a custom date range in the x-axis of a bar chart rather than calendar month? User must be able to select the start date from filter and month should be calculated 30 days from the selected start date.

Content (required):

For a dataset with columns date and value we need to plot a bar chart with x axis as month and y axis as aggregate of value. But the x axis should not take calendar month, instead it should get the month start from a filter.

Consider below dataset,

By default, the graph shows bar's for month 2 and 3 with value as aggregate of ‘value’ field.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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