We have a requirement where we want to display 1 month, 3 month, 6 month rolling average in the same line chart. These rolling averages are calculated during run time and then displayed on the chart. We are able to display these values properly using 3 line charts but we are unable to display all the 3 rolling averages in the same chart!
I am attaching a sample file which consists of sample input data and for reference I have also calculated 1 month, 3 month, 6 month rolling averages and the target line chart that we wish to showcase on Tableau!
Please help !