Can you create a query (or several queries) that generate data like this?
Maybe something like
SELECT product, obsolete_time FROM your_table ORDER BY obsolete_time;
Using data shown above, the State timeline graph looks like this. Not really great, but it gets the point across. Am sure you could tinker with it to show green fill prior to the expiration date and then red after the expiration date.
I got the same, and it was only when I separated them out as 3 distinct queries did I get the results as 3 separate bars. There may be a transformation or setting somewhere to avoid this, but I could not find it.
Were you able to get it working with these 2 transformations? The “Extract fields” transformation parses the fields (in your case, the Product field) and then the “Organize fields” transformation allows us to hide the first one displayed since it was like the original (all 3 products collapsed into one bar).
I played around with this earlier today and found one can do Gantt-style charts using the State timeline. It requires a bit of data manipulation, but as you can see it does work.