CODEWITHSUNDEEP
tableau-desktop
SeaSweeper
SeaSweeper

Reputation: 3

Tableau turning my duration data into date data

I'm just trying to make a simple line chart in Tableau Desktop from some very simple data.

Data in Google Sheets

The Date Row is formatted as Plain Text. The members and casual riders rows are formatted as 'Duration'.

However, when I DL the data to my pc and then add this data to Tableau, Tableau is turning my duration data into Calendar data for some reason.

What it looks like in Tableau

Not sure why it's doing that, but it's stopping me from making what should be a very easy line chart.

Any help would be appreciated.

Upvotes: 0

Views: 55

Answers (1)

Debayan
Debayan

Reputation: 854

It would be really useful to utilize the Data Cleaning options from Tableau Prep

If you open the .tflx file, you will understand that I applied certain steps to obtain a cleaned dataset, you may rename the columns as required. In the last step, you can either save the output dataset as a Tableau .Hyper file or an xlsx/csv file

Download Tableau Prep (it uses same license as tableau)

enter image description here

Upvotes: 0

Related Questions