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:
Then I could plot it all in Tableau:
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…
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:
Then change the Time format to Custom> HH:mm:
You can then drag a dimension to the Rows shelf and colour as required:
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:
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:
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