Hello
I have data that is being summed from three columns and then plotted over a categorical date in a combination plot. I would like to configure the plot so that I can use the date categorical slider to show the monthly total or the average monthly value for an entire year. If I use a formula Sum([Column A]) + sum([Column B] + sum([Column C]) then the value is correct for the individual month. The visualization sums the values for each entire year year if I slide the date slider to (Year). Is there a way to get the monthly average when the slider is kicked over to the (Year) setting? Over [Axis.X] is invalid, Avg(Sum + Sum + Sum) Over [Axis.X] also shows as invalid.
Thank You!!!
I didn't find the right solution from the Internet.
References
https://community.tibco.com/questions/average-sums-monthly-year-or-monthly-plot
