This content has been marked as final. Show 2 replies
I have created a chart with below sample values for 4 months.
Date, Count of Sales
Later I created a graph to calculate monthly total of sales using dimension as = Month(Date) &"-" & Year(Date).
Now If I have to add median/avg line of Monthly sale on this chart how to get it added?
When I created simple graph of date Vs Count, I was able to add Two refernce lines using Avg(Count of Sales) and Median(Count of Sales) functions for reference line of graph.
But when I create monthly aggregation of data, I don't know how to add correct "avg/median function" for this table.
Any help will be appreciated.