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