Content in Tableau Community Forums

Can I allow users to change moving average window?

tableaucommunity@tableau.com — Mon, 16 Oct 2017 14:25:44 GMT

I'd like to be make it possible for my users, via their browser, to modify the time window used for a moving average table calculation. The default presentation is 7 days. I'd like to make it possible for users to shorten or extend this to 1 day or 30 days, for instance. Is this possible?

How to drop Tableau_sid tables in MySQL

tableaucommunity@tableau.com — Tue, 25 Mar 2014 03:07:45 GMT

Over the last year I've collected a few tables with names like "#Tableau_sid_0000082E_7_none_RegCountry_nk" in my MySQL DB. I believe these are due to connections that were lost along the way. I'm not concerned with how they got there. What I'd like to know is how to drop them as I can't tell how to escape the comment character '#'.

I've tried various combinations with 'drop table'. But I'm not hitting on the correct character escaping or quoting to get rid of them. I get either "ERROR 1064 (42000) at line 1: You have an error in your SQL syntax..." or "ERROR 1051 (42S02) at line 1: Unknown table...". And the documentation that I thought would address this doesn't:

MySQL :: MySQL 5.5 Reference Manual :: 9.1.1 String Literals

filter based on mysql datetime

tableaucommunity@tableau.com — Tue, 11 Feb 2014 03:45:40 GMT

I'm attempting to filter data based on a MySQL timestamp field, with both a Data Source Filter and a Filter card entry. I'd like the Data Source Filter to limit the data to the last 2 or 4 weeks. And I'd like the Filter card entry to allow users to look at a more narrowed range.

This seems like such a basic thing I'm sure I'm doing something very stupid. But nothing that I try is working. I've been looking at the log entries and see that Tableau is introducing cast operations that are upsetting MySQL.

Tableau shows that it has recognized that the field is a date/time with the icon of a calendar and clock. Simply putting this into a filter entry with Relative dates I get a dialog box with this message:

[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.27]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (`PlayerSpawns`.`StartTime_ts` < (CAST({ts '2014-02-11 00:39:48'} AS DATE' at line 4

Here's the query that I find in the log file:

SELECT `PlayerSpawns`.`MechSubType` AS `none:MechSubType:ok`,

SUM(1) AS `sum:Number of Records:ok`

FROM `PlayerSpawns`

WHERE ((`PlayerSpawns`.`StartTime_ts` >= (CAST({ts '2014-02-11 00:39:48'} AS DATE) + (-2) * INTERVAL '1' DAY)) AND (`PlayerSpawns`.`StartTime_ts` < (CAST({ts '2014-02-11 00:39:48'} AS DATE) + 1 * INTERVAL '1' DAY)))

GROUP BY 1

This approach for adding an interval to a date isn't supported. Is it possible that this is due to the version of the ODBC driver I'm using so I can have a secure connection to the DB? I know my DSN connection has some limitations. But I clicked the 'don't show me this dialog box again' option, so now I don't know just what limitations Tableau has with it.

I have tried other approaches to work with this field. But those all result in casting problems. Unless someone can suggest an alternative to these I think I'll have to go the 'custom SQL' route which I was trying to avoid.

Using Google 2-step verification with a Data Connection

tableaucommunity@tableau.com — Fri, 17 Jan 2014 22:48:26 GMT

I use Google's 2-step Verification and Application-Specific Passwords with my gmail account. I cannot find a way to have Tableau save the password. When I attempt this I'm told that I need to use my usual, non-app-specific, password. I don't ever have an opportunity to enter the app-specific password. When it's time to update the data the job always fails. Is there a way around this?