Systems and methods for timeline visualization
Systems and methods of timeline visualization that define a table structure which represents supply chain management actions in a generic way. The content of the table is then processed by the timeline visualization to extract the entities, events, their relationships, and their attributes. These entities are transformed into time axes, while the events are transformed into a visual representation of their attributes using color, shapes, and text labels. The events may be positioned on a canvas, above or below a timeline axis, depending on whether they are upstream or downstream events, using a layout module which determines the position on the x-axis (time) and y-axis.
1. A computer-implemented method comprising:
applying, by a processor, a set of mappings and one or more settings to a worksheet data, thereby producing a mapped worksheet data;
creating, by the processor, a data model based on the mapped worksheet data, the data model comprising timeline data and legend data;
computing, by the processor, based on the timeline data, one or more timelines, each timeline comprising a timeline axis, a second axis, each timeline associated with one or more events, wherein for each timeline, the computer-implemented method comprises:
computing by the processor, a position for each event, each event being categorized as a first type of event or a second type of event,
displaying, by the processor, each event in chronological order along the timeline axis, the first type of event being displayed on a first side of the timeline axis and the second type of event being displayed on a second side of the timeline axis opposite the first side; and
displaying, by the processor, a subset of the one or more events displaced along the second axis in a non-chronological order according to an attribute associated with the subset of the one or more events.
2. The computer-implemented method of claim 1 , further comprising: listening, by the processor, for one or more user input events.
3. The computer-implemented method of claim 1 , wherein:
the set of mappings comprise a data mapping and a style mapping;
the data mapping comprises one or more categories of mappings; and the computer-implemented method further comprises: applying, by the processor, the data mapping to one or more columns of the worksheet data.
4. The computer-implemented method of claim 3 , wherein the style mapping customizes a symbol and a colour for each series of events of the one or more events.
5. The computer-implemented method of claim 3 , wherein the one or more categories of mappings comprises a timeline mapping, an instant event mapping, and an interval event mapping;
the instant event mapping and the interval event mapping each comprise a date mapping, a label mapping and a tooltip mapping;
the date mapping of the instant event mapping accepts one or more date columns of the worksheet data, each date column representing a single series of a type of instant event;
the date mapping of the interval event mapping accepts a pair of date columns of the worksheet data, each pair of date columns representing a single series of a type of interval event;
the label mapping accepts one or more attribute columns of the worksheet data, a content of each of the one or more attribute columns displayed on a label associated with a respective event; and
the tooltip mapping accepts one or more item identifiers.
6. The computer-implemented method of claim 1 , wherein there are a plurality of timelines, and the computer-implemented method further comprises: displaying, by the processor, vertical stacking of the timelines.
7. The computer-implemented method of claim 1 , further comprising:
limiting, by the processor, displacement of events along the second axis based on input by a user;
creating, by the processor, an overflow of one or more hidden events that exceed the displacement.
8. A computing apparatus comprising: a processor; and a memory storing instructions that, when executed by the processor, configure the computing apparatus to:
apply, by the processor, a set of mappings and one or more settings to a worksheet data, thereby producing a mapped worksheet data;
create, by the processor, a data model based on the mapped worksheet data, the data model comprising timeline data and legend data;
compute, by the processor, based on the timeline data, one or more timelines, each timeline comprising a timeline axis, a second axis, each timeline associated with one or more events, wherein for each timeline, the computing apparatus is further configured to:
compute by the processor, a position for each event, each event being categorized as a first type of event or a second type of event,
display, by the processor, each event in chronological order along the timeline axis, the first type of event being displayed on a first side of the timeline axis and the second type of event being displayed on a second side of the timeline axis opposite the first side; and
display, by the processor, a subset of the one or more events displaced along the second axis in anon-chronological order according to an attribute associated with the subset of the one or more events.
9. The computing apparatus of claim 8 , wherein the instructions further configure the computing apparatus to:
listen, by the processor, for one or more user input events.
10. The computing apparatus of claim 8 , wherein:
the set of mappings comprise a data mapping and a style mapping;
the data mapping comprise one or more categories of mappings; and the instructions further configure the computing apparatus to: apply, by the processor, the data mapping to one or more columns of the worksheet data.
11. The computing apparatus of claim 10 , wherein the style mapping customizes a symbol and a colour for each series of events of the one or more events.
12. The computing apparatus of claim 10 , wherein the one or more categories of mappings comprises a timeline map, an instant event mapping, and an interval event mapping;
the instant event map and the interval event mapping each comprise a date mapping, a label mapping and a tooltip mapping;
the date mapping of the instant event mapping accepts one or more date columns of the worksheet data, each date column representing a single series of a type of instant event;
the date mapping of the interval event mapping accepts a pair of date columns of the worksheet data, each pair of date columns representing a single series of a type of interval event;
the label map accepts one or more attribute columns of the worksheet data, a content of each of the one or more attribute columns displayed on a label associated with a respective event; and
the tooltip map accepts one or more item identifiers.
13. The computing apparatus of claim 8 , wherein there are a plurality of timelines, and the computing apparatus further comprises: display, by the processor, vertical stacking of the timelines.
14. The computing apparatus of claim 8 , wherein the instructions further configure the computing apparatus to: limit, by the processor, displacement of events along the second axis based on input by a user; create, by the processor, an overflow of one or more hidden events that exceed the displacement.
15. A non-transitory computer-readable storage medium including instructions that when executed by a computer, cause the computer to:
apply, by a processor, a set of mappings and one or more settings to a worksheet data, thereby producing a mapped worksheet data;
create, by the processor, a data model based on the mapped worksheet data, the data model comprising timeline data and legend data;
compute, by the processor, based on the timeline data, one or more timelines, each timeline comprising a timeline axis, a second axis, each timeline associated with one or more events, wherein for each timeline, wherein the instructions further configure the computer to:
compute by the processor, a position for each event, each event being categorized as a first type of event or a second type of event,
display, by the processor, each event in chronological order along the timeline axis, the first type of event being displayed on a first side of the timeline axis and the second type of event being displayed on a second side of the timeline axis opposite the first side; and
display, by the processor, a subset of the one or more events displaced along the second axis in anon-chronological order according to an attribute associated with the subset of the one or more events.
16. The non-transitory computer-readable storage medium of claim 15 , wherein the instructions further configure the computer to:
listen, by the processor, for one or more user input events.
17. The non-transitory computer-readable storage medium of claim 15 , wherein:
the set of mappings comprise a data mapping and a style mapping;
the data mapping comprises one or more categories of mappings; and
the instructions further configure the computer to:
applying, by the processor, the data mapping to one or more columns of the worksheet data.
18. The non-transitory computer-readable storage medium of claim 17 , wherein the style mapping customizes a symbol and a colour for each series of events of the one or more events.
19. The non-transitory computer-readable storage medium of claim 17 , wherein the one or more categories of mappings comprises a timeline map, an instant event mapping, and an interval event mapping;
the instant event map and the interval event mapping each comprise a date mapping, a label mapping and a tooltip mapping;
the date mapping of the instant event mapping accepts one or more date columns of the worksheet data, each date column representing a single series of a type of instant event;
the date mapping of the interval event mapping accepts a pair of date columns of the worksheet data, each pair of date columns representing a single series of a type of interval event;
the label map accepts one or more attribute columns of the worksheet data, a content of each of the one or more attribute columns displayed on a label associated with a respective event; and
the tooltip map accepts one or more item identifiers.
20. The non-transitory computer-readable storage medium of claim 15 , wherein there are a plurality of timelines, and wherein the instructions further configure the computer to:
display, by the processor, vertical stacking of the timelines.
21. The non-transitory computer-readable storage medium of claim 15 , wherein the instructions further configure the computer to:
limit, by the processor, displacement of events along the second axis based on input by a user;
create, by the processor, an overflow of one or more hidden events that exceed the displacement.