Usage and example of Redial Progress

This topic describes examples of how to configure the Radial Progress web extension and create two radial charts. In the examples, random numbers are used to demonstrate positive and negative variants.

Adjusting cells size

Adjust the size of the cells for two Radial Progress web extensions.
  1. Create an Application Studio report with the Planning: Net Revenue and Costs name.
  2. Right-click row 6 and select Rows.
  3. In the Row Properties dialog box, select Custom and set the height to 1.667 inches.
  4. Select Allow Growth and set Maximum to 2.125 inches.
  5. Select Allow Shrinkage and set Minimum to 1.563 inches.
  6. Click OK.
  7. Right-click column B and select Columns.
  8. In the Columns Properties dialog box, select Custom and set the widths to 2.500 inches.
  9. Select Allow Growth.
  10. Select Allow Shrinkage and set Minimum to 1.042 inches.
  11. Click OK.
  12. Repeat steps 7 to 12 for column D.

Creating the Recalculate button

With the Recalculate button, you recalculate the report and generate new values.
  1. In the B1 cell, specify Planning: Net Revenue and Costs as the name of the report.
  2. Highlight the B2 cell and select Insert > Objects > Command Button.
  3. Right-click the B2 cell and select Format Button.
  4. In the Format Button dialog box, specify this information:
    Name
    Specify Recalculate.
    Caption
    Specify Recalculate.
    Tooltip
    Specify Recalculate the report.
  5. Select the Click to execute an action check box and click the three-dot icon.
  6. In the Define Action dialog box, specify this information:
    • Actions section:
      Type
      Specify Set parameters.
      Condition
      Specify =TRUE.
      Mode
      Specify Button click.
    • Inputs/Outputs section:
      Name
      Specify Enforce recalculation of whole report.
      Value
      Select this check box.
  7. To close the Define Action dialog box, click OK.
  8. To close the Format Button dialog box, click OK.

Creating a data grid

You can create a data grid with values for the charts of the Radial Progress web extension. A random spreadsheet method is used to create the values. Use the Recalculate button to generate new values.
In the A9:D14 cell range, insert this table:
Field Left chart Blank column Right chart
Value =(RAND()+0.8)*100 =(RAND()+0.8)*100
Title Net Revenue Costs
Description If Impact is set to TRUE, values over 100% are positive. If Impact is set to FALSE, values over 100% are negative.
Font size 1em 1em
Impact TRUE FALSE

Configuring the Radial Progress web extension

Configure two Radial Progress web extension charts with references to the data grid.
  1. In the B6 cell, insert the Radial Progress web extension.
  2. In the Format Web Extension dialog box, specify these values:
    Value
    Specify =B10.
    Title
    Specify =B11.
    Description
    Specify =B12.
    Font Size
    Specify =B13.
    Font Color
    Specify ="#000000".
    Impact
    Specify =B14.
    Apple Watch
    Specify ="FALSE".
  3. In the D6 cell, insert the Radial Progress web extension.
  4. In the Format Web Extension dialog box, specify these values:
    Value
    Specify =D10.
    Title
    Specify =D11.
    Description
    Specify =D12.
    Font Size
    Specify =D13.
    Font Color
    Specify ="#000000".
    Impact
    Specify =D14.
    Apple Watch
    Specify ="FALSE".
  5. Click OK.
  6. Save the report.
    You can view the report in a web browser.