Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Mar 25, 2020 8:44 AM
(1410 views)

Hi,

I need some help to visualize horizontal duration lines in graph builder.

Therefore, I have three columns with data:

Column A: product type

Column B: duration cummulated

Column C: duration per product type

I want to illustrate on the x-axis the duration cummulated

On th y-axis, the different product types shall be illustrated.

The graph shall show the start and the end point for producing a specific product type.

Thereby, the production of product B starts when product A is finished, product C starts when product B is finished and so on.

I have attached a simplified JMP data table for better understanding. Is it possible to illustrate horizontal duration lines with the available data?

Many thanks in advance for your support. @martindemel

Best Regards

Konstantinos

2 ACCEPTED SOLUTIONS

Accepted Solutions

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

I do not know if this kind of result is what you are looking for:

If so, then create a new column that contains the start of the duration. Use the cumulative result for the end. Drag the start to the X drop zone. Drag the cumulative to the same drop zone but drop it just above the axis so it joins the start. Change the element to Bar. Change the style to Interval.

Learn it once, use it forever!

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Here is another way of doing the chart

```
Names Default To Here( 1 );
dt = Current Data Table();
dt << New Column( "Min",
Numeric,
"Continuous",
Format( "hr:m:s", 13, 0 ),
Input Format( "hr:m:s", 0 ),
Formula( :Duration cummulated - :Duration per production type )
);
dt << New Column( "Max",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula( :Duration cummulated ),
Set Selected
);
dtStack = dt << Stack(
columns( :Min, :Max ),
Source Label Column( "Label" ),
Stacked Data Column( "Data" )
);
dtStack:Data << format(":day:hr:m");
Graph Builder(
Size( 543, 456 ),
Show Control Panel( 0 ),
Variables( X( :Data ), Group Y( :Production Type ) ),
Elements( Line( X, Legend( 12 ), Error Interval( "Range" ) ) ),
SendToReport(
Dispatch(
{},
"",
ScaleBox,
{Label Row(
{Automatic Tick Marks( 0 ), Show Major Labels( 0 ),
Show Major Ticks( 0 ), Show Minor Ticks( 0 )}
)}
),
Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
12,
Properties( 0, {Line Width( 9 )}, Item ID( "Count", 1 ) )
)}
),
Dispatch( {}, "graph title", TextEditBox, {Set Text( "Gantt Chart" )} )
)
);
```

Jim

3 REPLIES 3

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

I do not know if this kind of result is what you are looking for:

If so, then create a new column that contains the start of the duration. Use the cumulative result for the end. Drag the start to the X drop zone. Drag the cumulative to the same drop zone but drop it just above the axis so it joins the start. Change the element to Bar. Change the style to Interval.

Learn it once, use it forever!

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Here is another way of doing the chart

```
Names Default To Here( 1 );
dt = Current Data Table();
dt << New Column( "Min",
Numeric,
"Continuous",
Format( "hr:m:s", 13, 0 ),
Input Format( "hr:m:s", 0 ),
Formula( :Duration cummulated - :Duration per production type )
);
dt << New Column( "Max",
Numeric,
"Continuous",
Format( "Best", 12 ),
Formula( :Duration cummulated ),
Set Selected
);
dtStack = dt << Stack(
columns( :Min, :Max ),
Source Label Column( "Label" ),
Stacked Data Column( "Data" )
);
dtStack:Data << format(":day:hr:m");
Graph Builder(
Size( 543, 456 ),
Show Control Panel( 0 ),
Variables( X( :Data ), Group Y( :Production Type ) ),
Elements( Line( X, Legend( 12 ), Error Interval( "Range" ) ) ),
SendToReport(
Dispatch(
{},
"",
ScaleBox,
{Label Row(
{Automatic Tick Marks( 0 ), Show Major Labels( 0 ),
Show Major Ticks( 0 ), Show Minor Ticks( 0 )}
)}
),
Dispatch(
{},
"400",
ScaleBox,
{Legend Model(
12,
Properties( 0, {Line Width( 9 )}, Item ID( "Count", 1 ) )
)}
),
Dispatch( {}, "graph title", TextEditBox, {Set Text( "Gantt Chart" )} )
)
);
```

Jim

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Graph Builder Horizontal Duration Line

Many thanks!

Article Labels

There are no labels assigned to this post.