Hi All,
I have a data table with a bunch of units that fall into different categories for different periods of time. This data set is defined in the data table as here: There are four columns of data – (i) unit identifier (a discrete number), (ii) start date, (iii) end date and (iv) category. The category column lists the categories into which the unit falls into between the start and end time. A given unit can have multiple rows of data corresponding to various periods. The data table is as attached.
I am trying to create a graph – with X axis as the time, Y axis as unit, and for each unit, I need a horizontal bar chart that shows the category by a color for the given time period. I am attaching a graph sketch to show how the graph should look like. The sketch is to drive my idea of the graph.
I tried my best, but could not get to what I was looking for. Appreciate your help on this. Either through a graph builder, or a JSL script is fine. I am using JMP 16 pro.
