htt

Software & Programme

Building out Gantt Charts

von
Charts

I was recently on a customer engagement and had an interesting challenge presenting data which I would like to share as it opened up some new possibilities for me to present compact and meaningful charts. Build with Alteryx and Tableau.

I had been compiling mobile telephone network signal strength statistics using the OpenSignal App to get my location, coordinates and BTS tower ID and then doing a lookup of the BTS tower against OpenCellID. I also needed another lookup to convert my Mobile Operator (Telekom.de)  to its Mobile Network Code (1)  to avoid duplicate BTS tower entries. This was all easily achieved in Alteryx:

mobile-telephone-network-signal-strength-statistics-us20

Then I could plot it all in Tableau:

data-plot-tableau-us20

Now the interesting thing here was finding a way to plot the network types with durations on a time axis. The customer had tried bar charts and I suggested Gantt charts but they had some limitations when trying to only plot hours along the axis as the axis expects days so we had to convert the time in to decimals of days.

Anyway once we had done this it was possible to plot the full time range along the horizontal axis which was fine for 1 day but trying to plot a month gave a very long chart which was useless for overviewing several days. In the end we came up with the following…

data-plot-2-tableau-us20

This allows plotting the date along the vertical axis whilst still plotting clock time only along the horizontal.

Here’s how I did it. First put the time on the Columns shelf as Exact Date continuous:

data-plot-3-tableau-us20

Then change the Time format to Custom> HH:mm:

data-plot-4-tableau-us20

You can then drag a dimension to the Rows shelf and colour as required:

data-plot-5-tableau-us20

To remedy this here is what I did. First from the Time dimension create a clock time dimension that we will use for the time only. Because we will only use it for the time element I set a fixed date part like so:

data-plot-6-time-tableau-us20

When we replace our time with this then we get all results over a 24 hour range and can then use MDY(Time) to partition the results by day:

data-plot-6-end-tableau-us20



Lösungen, die eine fundierte Entscheidungsfindung sicherstellen?

Informationen für Ihr Unternehmen, die qualitätsgesichert, entscheidungsrelevant sind und anspruchsvolle Geschäftsanalysen bieten? Gerne unterstützen wir Sie hierbei und stehen Ihnen für eine individuelle Fragen zur Seite. Tel.: +49 (0) 70 31 714-6215 oder per Kontaktformular


Richard Raistrick

Über den Autor 

BA-Universität Sheffield. 12 Jahre Erfahrung als Enterprise Software Technical Consultant/Ingenieur bei einem der weltweit größten Softwareunternehmen. Seit Anfang 2014 bei der Insight Dimension GmbH als Consultant / Entwickler tätig.

Building out Gantt Charts Reviewed by on .

I was recently on a customer engagement and had an interesting challenge presenting data which I would like to share as it opened up some new possibilities for me to present compact and meaningful charts. Build with Alteryx and Tableau. I had been compiling mobile telephone network signal strength statistics using the OpenSignal App to

Hinterlasse einen Kommentar

Your email address will not be published. Required fields are marked ( required )