5 Replies Latest reply on May 20, 2017 10:46 PM by Prayson Wilfred Daniel

# Analysis of speed (distance/time) in visualization

Hi folks,

I'm recreating two graphs in Tableau, from an external reporting website/resource.

I am using Tableau Professional Version 10.2.1.

These are the two following images are from the other resource, that I am making progress recreating in Tableau.

This first one shows (from top to bottom) Heart Rate, Cadence, and Speed.

The X-Axis shows distance.

This one shows the same metrics.

The X-Axis shows time, arbitrarily in 5 minute intervals.

I have partially succeeded in recreating these graphs in Tableau, for both X-Axis time, and distance.

In other words, I can see Heart Rate, and Cadence, by either time or distance. Take a look at the sheets "MetricsByRunTime" and "MetricsByKM".

I am having difficulty showing speed.

In the attached workbook, I have a sheet named "SpeedExperimentalByTime", where I can show the speed in km/h by time.

This graph is incomplete, and I'm having a difficult time deciding how to proceed.

If I select "TrackpointTime" (as an Exact Date) for Columns, and my calculated field "SpeedKMH" in Rows, I can see a graph that shows speed.

However, I don't want to see TrackpointTime along the X-Axis. I want to see Time from Start along the X-Axis.

If I change columns to RunTimeMinutes (calculated), and rows to SpeedKMH, I get the message:

"The table calculation for SpeedKMH requires a field that is missing. Please add the missing field to the view.".

I wonder how I should proceed.

Richard

• ###### 1. Re: Analysis of speed (distance/time) in visualization

I have one other question.

How can I show the range for Min, Max, and Avg of Heart Rate using different colored marks?

If you could show how I could accomplish that, on the "MetricsByRunTime" sheet, I sure would appreciate it!

Thanks!!!

• ###### 2. Re: Analysis of speed (distance/time) in visualization

This is because Trackpoint is used in your Quick Calculation as Computing Using

IF you place RunTimeMinutes (Analysis Disaggregate it), then Compute Using Table(across) you will not have any issue.

1 of 1 people found this helpful
• ###### 3. Re: Analysis of speed (distance/time) in visualization

I am not sure what you mean. Do you have a screenshot or MS Paint drawing that captures your thoughts?

• ###### 4. Re: Analysis of speed (distance/time) in visualization

Hi Prayson,

Thank you very much for your help.

Due to your assistance, I have been able to add the Speed line onto the "MetricsByRunTime" sheet.

You can see it here:

See the legend on the right?

How can I show that on the "MetricsByKM" sheet:

Thank you very much, I hope you are having a great day!

Richard

• ###### 5. Re: Analysis of speed (distance/time) in visualization

Do this:

Reset Cards will make the Colour Legend appear.

1 of 1 people found this helpful