There are a variety of things you can do here, including coloring by Polygon_id or a calculation based on X,Y or Z. Now, when you change the parameter values, the model will rotate. You can now use these calculated fields in place of X, Y, and Z. The formulas calculate projection onto a plane. I copied and pasted the calculations from Anya’s workbook . įor rotation you will need to create 3 parameters: XY-Angle, XZ-Angle, YZ-Angle and 3 calculations: x_rotated, y_rotated and z_rotated. You can find out more about the algorithm. The painter’s algorithm sorts all the polygons in a scene by their depth and then paints them in this order, farthest to closest. You can notice that the polygons on the pic above were sorting by Y axis in ascending order, so it can explain by painter’s algorithm. Use the X,Y and Z fields for creating a preview, so you can check you model at a glance.
STL file in Excel, check ‘space’ as delimeter We only need to keep the rows with a prefix of “vertex”, then numerate the rows. STL format contains data about vertex coordinates (X,Y,Z) for each polygon with 3 vertices. .STL is a text format, so you can use Notepad for opening and editing it (I use Notepad++).
You can find my code here: īut you do not need Alteryx or Python to get data from. I, like many others, don’t have an Alteryx license so I used a Python script for parsing the files. Anya’s blog contains a link to an Alteryx flow which converts the STL file to a TDE (Tableau Data Extract). Each row in a STL file represents a vertex and the format works with only triangles (polygon with 3 vertices). One such process is described in Anya’s article. These tools allow you to export your model to ASCII STL (stereolithography) files. There are a number of tools available for creating 3D models, including Blender (free), Meshlab (free), or SketchUp (not free). The Tableau community is so amazing and I have personally be inspired by all these methods, having used them to create some of my own 3D models in Tableau. If you have not seen the above or read these blogs, please take a few minutes to do so.
And Anya A’Hearn worked with Philip Riggs built the STL to TDE/Hyper convertor in Alteryx, as detailed in The 3D Full Monty.īig thanks to Allan Walker, who shared the above history with me. Allan Walker applied “shaders” – Guassian filters, slope, smoothstep functions. Bora Beran simplified his technique in his blog, Going 3D with Tableau. Noah Salvaterrapioneered these techniques when he created a 3D Tesla. I’m definitely not the first person to build 3D models in Tableau.
0 kommentar(er)
