Content in Tableau Community Forums

Is it possible to show the moving average using values not on a window (w/o using WINDOW_AVG)

tableaucommunity@tableau.com — Fri, 22 Feb 2013 21:19:03 GMT

I want to show the moving average from a specific date that may or may not be included in the user's date range selection (what wouldn't be shown in the window view).

If this isn't enough information to go on I will try to explain more in dept however, it is hard to explain what I'm trying to do.

Thanks in advance.

EDIT:

Ive attach a sample workbook. I want to find the moving average of the Defect Containment Rate (DCR). For example if I select the From Date as March, 2012 and the To Date as January, 2013 it shows the moving avg above April 2012 as the same as the DCR (which is incorrect for what I am trying to do). I'm positive this is because WINDOW_AVG says that there are no data entries before April, 2012. ( it only collects data that is visible on the window). However if you change the from date to March, 2012 the Moving Avg above April, 2012 changes because it includes March 2012 in the calculation. I want to know is there a way of including the data (e.g. March 2012 data) of items not shown on the window.

I hope this explains what I am trying to do better.

Message was edited by: Tremain Keith

Is it possible to show a 13 month trend?

tableaucommunity@tableau.com — Thu, 14 Feb 2013 19:35:41 GMT

If it is possible I want to know how you would show a 13 month trend instead of a 12 month (i.e. instead of showing data from Jan 2012 to Dec 2012, show data from Dec 2011 to Dec 2012). It seems like there should be a way to show 2 years or data and just filter the 13 months you want to see.

Thanks in advance for your help!

Is there a way to modify the query that gets ran when tableau fetches data?

tableaucommunity@tableau.com — Thu, 07 Feb 2013 19:01:03 GMT

I'm knew to tableau, and I know you can view the query that get executed in the log file, but is there a way to manually modify the sql query so you can get the results you want. (e.g. changing what columns are included in the select statement). I'm not referring to the custom sql that you can write to join tables together. Thanks in advance for the help