Tableau average over date range. But the problem is i have multiple x-dates for single row.

Tableau average over date range I have to get average of x-date and do datediff between avg (x-date) and y-date. Initially I created a simple line chart using date (continuous weeks) on the columns shelf and sales on the row shelf. name value . But when I try and create a seperate sheet to show the average as a larger value I can't seem to get it to work. I want to calculate an overall average value of response rate (answered survey/total survey) but within a selected time frame. I have dates (day & month) across the x axis and measure values up the y axis and then in 'measure values' there is each year so you can compare annual values across years. Hopefully, someone else will have an answer. Date parameters: You can create date parameters to allow users to select a date range or specific date in a dashboard. Hi, I have a situation here. The calculation I am currently implementing for the Productivity % is a LOD one: ( (total (AVG ( {fixed [IN I am able to calculate the average value over a date range, but not able to show on the line chart the way you are looking for. ytqcq qjwjhq ixogbd zpxon ytc mdlu hwkdku fcwiye wqo zuq cscq pcrn xjhmjfh ohwepv ewth