Tableau将我的持续时间数据转换为日期数据。

huangapple go评论91阅读模式
英文:

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.

英文:

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.

答案1

得分: 0

以下是要翻译的内容:

"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)"

Tableau将我的持续时间数据转换为日期数据。

英文:

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)

Tableau将我的持续时间数据转换为日期数据。

huangapple
  • 本文由 发表于 2023年5月14日 20:19:37
  • 转载请务必保留本文链接:https://go.coder-hub.com/76247442.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定