Overview

In a SAS Visual Analytics report, you might want to see difference between the values on a range slider and use that value in calculations. To illustrate how this can be done, this sample shows you how to capture the number of days between two dates selected on a range slider. In the following display, there is an interaction from the range slider to the list table and to the speedometer. This means that both objects are updated based on the current selection in the range slider. In this display, the range slider is set from April 11 through April 19. The table and speedometer are updated to display results for those days, and the number of days between April 11 and April 19 (8) is displayed in the Range days column in the table.

About the sample

This sample assumes that you have the capabilities and permissions necessary to use SAS^® Management Console, the SAS^® Visual Analytics Administrator, and SAS Visual Analytics Designer.

This sample also assumes that you know how to register a table in metadata, load a table, and create a report.

Create the sample table

The following sample code creates a new table based on SASHELP.CLASS. The new table contains a column named mydate. If you want to follow along with this sample, you can submit similar code, and then register the classmydate table in metadata using SAS Management Console.

Create the SAS^® LASR™ Analytic Server table

1. Log on to the SAS Visual Analytics home page, and click Manage Environment to launch SAS Visual Analytics Administrator.
2. In the Folders pane, navigate to the table that you registered in SAS Management Console.
3. Right-click the table and select Load a Table.
4. Enter the required information, and then click OK to complete the load process.

Create the report

In the report, you are going to perform these tasks:

• Specify to use the date as a numeric value.
• Create two aggregated measures that represent the two values of the slider.
• Create a third aggregated measure named Range days.

1. On the home page, click Create Report to launch SAS Visual Analytics Designer.
2. Click the Data tab.
3. In order to create the calculated item, the date must treated as a numeric value. From the drop-down list, select New Calculated Item.
4. Drag the mydate data item to the Visual tab, and then drag over the numeric operator TreatAs. Use the default format _Number_. Name the new data item MyDateRaw..

   

5. From the drop-down list, select New Aggregated Measure.
6. Drag the Min function to the expression. Use the ForAll option. Drag the MyDateRaw data item to the expression. Name the new data item MyDateMin.



7. Repeat steps 5 and 6 to create another aggregated measure using the Max function. Name the data item MyDateMax.



8. Create a final aggregated measure named Range days. For this data item, enter the following expression:

MyDateMax - MyDateMin



9. Place the range slider, the list table, and the speedometer on the report. For the range slider, select MyDate as the date.
10. Create an interaction from the range slider to the list table and to the speedometer. Notice how the value of Range days in the table changes as you adjust the values on the range slider.

Additional Documentation

For more information about SAS Visual Analytics, see the SAS Visual Analytics documentation page.