I am trying to make a flight path between origin and destination. I changed the geographic role of origin to Airport. Tableau automatically generated latitude and longitude for the origin airport. Now, I want to store these values into one calculated field or save them individually back to the dataset. How to do it?
For the calculated field part it shows:
operations on the field [Latitude (generated) ] is not permitted.
How to save the latitude and longitude of the origin and dest airport?
Hi Neel,
First - forget about the lat/long for a minute. The initial objective should be to create an origin and destination dataset. You could either prepare this outside Tableau and then load it in, or you could get wild inside Tableau with some creative calculated fields, but in the end you should be able to identify origin and destination airports separately.
Then you can introduce lat/long. The makeline(makepoint([origin lat, origin long]), makepoint([dest lat, dest long])) function will begin to operate as expected as well once you have these structures in place.
If you need any further help with this, grateful if you could upload a sample .twbx showing your working so far.
HTH
Peter
