Any chance of some data or a workbook to help with your question ?
I don't quite understand the description, so even a mockup would help
Unfortunately for the sensitivity of the data I cannot share the workbook. What I can do is attempt to better explain through a test case.
Say I have 20 IT help tickets across Los Angeles that were each opened on a different date. They remained open for some period of time until they were closed, again on different dates. Therefore each ticket has a different duration of being open and a different location.
What I would like to do is show on a map of Los Angeles, each ticket appear on the date it was open and remain on the map until it was closed. Therefore I would have tickets appearing and dissapearing between the earliest open date and latest close date.
Thanks in advance!
Can you use Superstore data or anonymize your existing data (small set) and then upload a packaged workbook? We really need to see the data and how it acts to help in this case. Otherwise we will be speculating solutions.
Hello, after reviewing Superstore data I think it will help. Using "Order Date" as the origination date, "Ship Date" as the closing date, and "Postal Code" as the location information, is it possible to have the individual records appear on the map on their "Order Date" and remain on the map until their "Ship Date".
The closest I've gotten is using pages but using DAY "Order Date" will make each day a page and therefore once the next date shows up the previous date is gone. As shown in the two pics below.
Using "Show History" with "All" marks selected and "Last:" (number of pages) selected for "Length" is getting closer however, I have different "Lengths" when I take into account my "Ship Date".
Using the first record as an example, I would like it to show on the map on Jan 4, 2011 and stay on the map until the "Order Date" of the other records passes the first records "Ship Date" for which it will come off the map. Hope this helps and thank you for the help.
You'll need a calc to compare to today...
I created a parameter to use as a pseudo "today" in this calc:
IF [Order Date]<=[Parameter 1] AND [Ship Date]>=[Parameter 1] THEN [Postal Code] END
For your actual calc you'd use TODAY() in lieu of that Parameter
postalcodes.twbx 1.3 MB
It is saying I cannot open your workbook because it was created with a newer version of Tableau. I have 9.0, is there a compatibility mode or something you could save it with and re-upload? I would greatly appreciate it. I think you've got me on the right track! Thank you.
Daniel, you are the man. My data points are appearing and remaining on the map for their duration however, it is not 100% solved. I have bonus questions.
1. I am using latitude and longitude as my geographic location and not postal code since I need to display a close to exact location ( I have many data points in one postal code). The calculated field you created results in "Postal Code" which is fine for a singular need. Can it be converted to use latitude and longitude as the result?
2. Can I animate the map to run through the range of dates so I don't have to manually select the date in the parameter card? I'm working with thousands of dates.
Thank you so much for your help.
Yes, you can do this with Lat/Long. Just need to have two calc one for each
IF [Order Date]<=[Parameter 1] AND [Ship Date]>=[Parameter 1] THEN [Lat] END
IF [Order Date]<=[Parameter 1] AND [Ship Date]>=[Parameter 1] THEN [Long] END
Then put those on the corresponding row/column shelves.