Is there an option in OAC [Visualize Data] to get the filter value inside my calculation?
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.
Tagged:
0