I've got a dataset I'm trying to work with which is in JSON format, and I've hit a stumbling block due to the way the data is arranged and my use for it. This data set has start and end x,y coordinates which is stored in the same element (or row if you want to think about it in data/spreadsheet terms) as per below.
Index
x_start
x_end125.632.7246.2
34.8
378.282.5420.350.3527.248.9
(This is simplified, there's obviously y-coordinates included as well as a lot of other data)
Now I want to create a path but I believe I need to first combine the data into 1 field. I therefore need to merge these two Measures across then down to get it into a format suitable to display the path I require. Something like this:
Indexx-coordinate125.6232.7346.2434.8578.26....
....And so on
I would effectively be doubling the number of marks/rows involved.
Now I appreciate the best way would be to format the data before it is run in Tableau, but I can't control the data structure and to change it upon receipt would be a right pain to say the least. Is there any way I can re-create this process within Tableau or is this not possible.
Alternatively am I looking at this wrong? Would it be better to just create a calculated field that mimics this structure? After all that's all that's needed for the path id, but if that is the case how would I go about creating this considering I would be doubling the number of marks/rows.
By the way I'm new to Tableau (still learning) and am currently using Tableau Public.
Many thanks.
Index
If you want to display the lines or paths created and come back to a center point, as in a spider diagram, you will need to create a pathID field and a path order. The number of rows of data will be doubled because you need to get out from the starting point and back to the point. Without the return path, the second row, you wind up with a radar diagram. Is the image below something like you are trying to build?
