• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

19. Some Common Data Manipulation Problems > 19.6. Time to Completion II

Time to Completion II

Let’s make the time-to-completion problem more complicated. Imagine again that you are keeping track of the status of widget production for your company. Each widget is composed of four modules, each of which is assembled separately. Table 19-9 shows some sample data.

Table 19-9. Widgets table: Time to completion of multimodule widgets

WidgetID

ModuleID

TimeToCompletion

1

1

0

1

2

1

1

3

2

1

4

1

2

1

1

2

2

2

2

3

3

2

4

4

3

1

0

3

2

5

3

3

4

3

4

0

4

1

0

4

2

1

4

3

1

4

4

2

We are trying to determine the widgets in which Module 1 is the only completed module—that is, where TimeToCompletion is equal to zero for Module 1, but not for any of the other modules in the widget. Thus, for our table, Widgets 1 and 4 qualify.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint