Skip to main content
I
IoTProductMgmt5-Regular Member
5-Regular Member
November 2, 2022

Track Progress with Waterfall Chart Part 1

  • November 2, 2022
  • 0 replies
  • 615 views

 

Display project burn up/down via a convenient Mashup Widget.

 

GUIDE CONCEPT

 

Long term projects need to be managed. As a project is scoped, requirements get defined and delivery-timeframes are estimated. As work is done, requirements are completed.

 

One way to track this project progress is with a Waterfall Chart.

 

This guide will show you how to utilize a Waterfall Chart Widget to easily display the project workflow. 

 

00-tpwc-tile.png

 

 

YOU'LL LEARN HOW TO

 

  • Create a Data Shape
  • Create a Thing
  • Create an Info Table Property
  • Populate an Info Table with appropriate data for a Waterfall Chart
  • Create a Mashup
  • Utilize a Waterfall Chart to display project progress
 
NOTE: This guide's content aligns with ThingWorx 9.3. The estimated time to complete this guide is 30 minutes
 
 

Step 1: Create Data Shape

 

In this scenario, we'll store the Waterfall Chart's data in a Property type called an Info Table.

 

An Info Table is a spreadsheet-like Property, but in order to define the columns of the table, we first have to define a Data Shape. We'll do that in this step.

 

  1. In the left-side navigation, click Browse > Modeling > Data Shapes.

    02-tipc-data-shapes.png

     

  2. At the top, click + New.

    03-tipc-new-data-shape.png

     

  3. In the Name field, type TPWC_DataShape.

  4. If Project is not already set, search for and select PTCDefaultProject
    .
    01-tpwc-datashape-name.png

     

  5. At the top, click Field Definitions.

    05-tipc-field-defs.png

     

  6. At the top-left, click + Add.
     

    06-tipc-add-def.png

  7. On the right-side slide-out, in the Name field, type month.
    • Note that you want to leave "Base Type" as the default of "STRING".

  8. Check Is Primary Key.

    07-tipc-issue-type-02.png

     

  9. Click the "check with a plus" button for Done and Add.
     

    08-tipc-done-add-02.png

  10. In the Name field, type amount.

  11. Change Base Type, to NUMBER.

    02-tpwc-amount-field111111.png

     

  12. Click the "check" button for Done.
     
  13. At the top, click Save
    .
08-tipc-done-add-02.png

 

 

Step 2: Create Thing

 

Now that we have our Data Shape, we can create a Thing to document the project progress over time.

 

As already mentioned, we'll use an Info Table Property, formatted by the previously-created Data Shape, to do so.

 

  1. Click Browse > Modeling > Things.

    11-tipc-things.png

     

  2. Click + New.
     

    12-tipc-new-thing-02.png

  3. In the Name field, type TPWC_Thing.

  4. If Project is not already set, search for and select PTCDefaultProject.

  5. In the Base Thing Template field, search for and select GenericThing.

    04-twpc-thing-name.png

  6. At the top, click Save.

 

Add Info Table Property

Now that we have our Thing instantiated, we want to add an Info Table Property.

  1. At the top, click Properties and Alerts.

    05-twpc-properties.png

     

  2. Click + Add.

    06-twpc-prop-add.png

     

  3. On the right-side slide-out, in the Name field, type InfoTable_Property.

  4. Change Base Type to INFOTABLE.

  5. In the Data Shape field, search for and select TPWC_DataShape.
    • Note that the Data Shape field will not appear until you set Base Type to INFOTABLE.

  6. Check Persistent.
     

    07-twpc-prop-name.png

  7. At the top-right, click the "check" button for Done.

  8. At the top, click Save.

    08-twpc-prop-save.png

     

Set Value of Property

Now that we have a place in which to store spreadsheet-like values, we'll do so manually for testing. 

  1. On the InfoTable_Property row, under the Value column, click the "pencil" icon for Set value of property.
     

    19-tipc-set-value-of-property.png

  2. On the pop-up, click + Add.
     

    09-tpwc-add-first-default.png

  3. Enter the following values in each field as per the table below:

    Field NameValue
    monthJanuary
    amount380

    10-tpwc-january-380.png

     

  4. Click Add.

    11-tpwc-jan-added.png

     

  5. Repeat Steps 2-4 multiples times until all of the below values have been entered.
    • Note that amount should be left blank for both Mid-Term and Total.
    • Note that you may enter fewer than all the values listed below if so desired, though your final Waterfall Chart will not match the following screenshots.

      monthamount
      February85
      March50
      April1000
      May-300
      June0
      Mid-Term 
      July30
      August-655
      September-100
      October-250
      November350
      December-100
      Total 
       

      12-tpwc-all-defaults.png

  6. On the pop-up, click Save.
     

    13-tpwc-defaults-saved.png

  7. At the top, click Save.
 

Step 3: Create Mashup

 

Now that we have our data in-place for testing (and could be connected to automated systems after we finish testing), we need to visualize the data.

 

As mentioned, we'll use a Waterfall Chart Widget, but first, we need to create a Mashup into which we can place the Widget.

 

  1. Click Browse > Visualization > Mashups.
     

    26-tipc-mashups.png

  2. Click + New.
     

    01-uiv92-new-mashup-popup.png

  3. Leave the defaults and click OK.
     

    28-tipc-mashup-geninfo.png

  4. In the Name field, type TPWC_Mashup.

  5. If Project is not already set, search for and select PTCDefaultProject.

  6. At the top, click Save.
     

    14-tpwc-save-mashup.png

  7. At the top, click Design.
     

    15-tpwc-design.png

  8. At the top-left, click the Widgets tab.
     

    16-tpwc-widgets.png

  9. Drag-and-drop a Waterfall Chart Widget onto the central Canvas.
     

    17-tpwc-drag-drop-waterfall.png

  10. At the top, click Save.
 

 

Click here to view Part 2 of this guide.

Terms & ConditionsAccessibility statement