1 of 1 people found this helpful
Drag Product to Rows
Value to Text in marks sections
In marks section you will get SUM(Value) --> Right Click on It --> Aggregation --> Select "Average"
Drag date field to text and change the filter as per your need automatically you will get the average for each product
Hope this helps, Plz mark this answer as correct or helpful to close the thread
Thanks! If I put the PRODUCT and DATE in the filter and plot bar of each value of the product, do you know how can I put the average value in the title which if I change date range, the average value change? Thanks!