Content in Tableau Community Forums

String to Date conversion returns Null

tableaucommunity@tableau.com — Wed, 06 Apr 2016 12:47:48 GMT

I am connected live to Google BigQuery. I have a field [dayofpurchase] of string type and in the format of "DDMONYYYY: HH:MI:SS.000000". In Tableau, I created the following calculated field to get the format ready to be converted to date type:

MID([dayofpurchase],3,1)

+LOWER(MID([dayofpurchase],4,2))

+" "

LEFT([dayofpurchase],2)

+", "

+MID([dayofpurchase],6,4)

+" "

+MID([dayofpurchase],11,8)

This displays fine as a string in the format "Mon DD, YYYY HH:MI:SS", but when I try to convert it using the DATETIME function, it returns Null values. I've tried a few variation of the date format, same result. Any idea? From reading and researching online, it seems like this might be a BigQuery issue.

Running the following query in BigQuery: Select timestamp(dayofpurchase) from datatable; gave me Null values. Is there any workarounds?

tabcmd get packaged workbook with URL parameter

tableaucommunity@tableau.com — Mon, 12 May 2014 19:31:48 GMT

I'm using tabcmd to export a workbook as twbx from the server to a shared drive and would like to restrict the data using URL parameters. It works when I export a single view as pdf, png, etc. and here's the tabcmd I used:

tabcmd get "views/RevPerWafer/RevPerWafer.pdf?Technology=28NM" -f "C:\Users\TYEN\Documents\RevPerWafer.pdf"

Again, the above works and is filtering the data as desired, but the result is a static, single view, whereas I'm looking for a packaged workbook that the user can open with Tableau Desktop or Reader. I've tried applying the same syntax for workbook:

tabcmd get "workbook/RevPerWafer.twbx?Technology=28NM" -f "C:\Users\TYEN\Documents\RevPerWafer.twbx"

This runs fine (returns a "Succeeded" message and I'm able to open the workbook), but is not restricting the data and I can still see the whole data set in the workbook.

Is what I'm looking for possible? If so, how?

Any suggestions or guidance is much appreciated!

Cascade Parameteres

tableaucommunity@tableau.com — Fri, 10 May 2013 13:56:47 GMT

I'm building a dashboard that has multiple data sources, and therefore requires parameters (instead of filters) to filter across all data sources. In my data, I have a Product Item hierarchy, which has the structure Category > Group > Subgroup. I'd like to have parameters for the Item hierarchy, in a cascading manner, i.e. selecting a Category will reduce the selection lists for Group and Subgroup to values relevant only to the selected Category. From reading the forum, it seems like this feature can only be applied when using filters, is that true? If so, is there any workarounds?

Thanks!

Quarterly Sales Comparison

tableaucommunity@tableau.com — Tue, 07 May 2013 17:26:15 GMT

I am trying to compare quarterly sales with a bullet graph, much like the Sales Sample Workbook that came with Tableau (image attached), but instead of annual sales, I'm doing it by quarter. In the attached workbook, you can see that I've created something similar, but it's not exactly what I want. The graph I have right now displays Previous Quarter Sales as the bars and Current Quarter Sales as the lines, which is opposite of what I'm looking for. Ideally, I would like to have Current Quarter Sales on the bars and Previous Quarter Sales the lines. When I tried swapping the two pills, i.e. having Current on Columns and Previous on the Marks shelf, I can't quite recreate the bullet graph that I have right now. Does anyone know why that is and how I can get the display I want?

Any help and suggestions are welcome. Thanks!

Hour Display Format on the Axis

tableaucommunity@tableau.com — Wed, 01 May 2013 20:26:23 GMT

I have a Heat Map that shows sales trend for a particular week day at a particular time of the day (see first image). Now the Hours on the x-axis is displayed in Military Time, 0 through 23. I would like to have it in standard AM/PM format. I tried following this for Custom Date Formats: http://kb.tableausoftware.com/articles/knowledgebase/formatting-numbers-and-dates, but couldn't find the Scale shelf when I click on Format for Hour (see second image). Help!