I would like to show the time taken for a event to complete and the rolling 5 weeks average (the one that you calculated with the help of table calculations) for each timestamp. With the help of the table calculation I am able to achieve the following:
However I would like to get a chart like this : (I got this dual axis chart by plotting the 'timetaken' and the 'Rollingfourweekavg' on a Dual axis. Here I calculated the 'Rollingfourweekavg' values in the excel table before bring it into Tableau)
I know that with table calls there will be a restriction in the chart type that it can do. Is there a way we can achieve the 'Rollingfourweekavg' with a calculated filed and not use a table calc. As that would help me get the chart I need?
Regards,
Rishi Saka
Message was edited by: Deepak Rai
mention removed
