I want to build an indicator to show how many boxes have been produced of the goal amount.
For this I have calculated the angle by adding all the boxes, multiplying by 180 and then dividing by the total amount (or goal amount) of boxes. This changes depending on how much has been produced by certain hour, and that is chosen by using a filter.
[Palcapa] is the amount of boxes produced together at certain time (datetime).
Then I have calculated X and Y using polar coordinates:
And it works well, but only as a point, as I want it to be an indicator I want to connect this dot to the origin (0,0) and draw a line. I have tried many different approaches but I am not even close. The problem is a datetime is related to each X,Y point, but it follows no order, so it is not possible to do what it is shown is most tutorials. You can select the time using a parameter but it makes no sense.
It sounds really simple but is giving me a hard time. Any ideas?
I am using Tableau Desktop 2019.1.0
EDIT: the examples on the tutorial don't help much because what I'm trying is a little bit more complicated. A date is assigned to each point
Hi Amaia,
There are different tutorials for this:
Dueling Data: How To Create a Gauge Chart in Tableau (UPDATED)
https://www.kenflerlage.com/2018/01/percentage-gauges-in-tableau.html
null
https://lightpostanalytics.com/how-to-build-small-multiple-gauge-chart-in-tableau/
Hope this helps.
If this answers helps you or solves your question, please mark it as helpful/correct so other users can refer to it.
Best,
Diego