SAS Info Map: I want an Average not a Sum!
In SAS Information Map Studio, you can easily set the default measure for a data item in the Properties area. This advise will not apply to information maps based on a SAS OLAP Cube.
Change your Data Item Aggregation Defaults
(1) Use the Default aggregate function drop-down to select the default. When you set this item to AVERAGE, the data item defaults to Average in SAS Web Report Studio.
(2) You can control which aggregates are available to the data item. For instance, for a percentage (such as discount) you probably never want that to be SUM – so de-select it to prevent the action.
Based on the data item there will be different aggregation functions available. So a data item that is a percentage will not offer the same aggregations as a single number. Consider the following examples.
In this example – it’s a “normal” data item meaning it’s numeric. You can see that all the aggregate functions are available for it.
For this example, the data item is a calculated percentage. You can only choose if you want it the result to aggregate as additive or non-additive. (That’s another blog topic!)
Making Changes in Web Report Studio
You can also change the default aggregations for a report in SAS Web Report Studio. From the Edit pane, select Data > Summarization Options. In the Summarization Options window you can change how the data item works in the report. For instance, you may want to display Bounces as an Average instead of a sum. Notice that changes to the calculated data items (New Visitors (%)) is not allowed.
Learn all about SAS BI
You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.
Latest posts by Tricia Aanderud (see all)
- Use these 7 Data Storytelling Examples to Make Your Insights more Meaningful Today - 2018-06-09
- Use Network Analysis to Understand Your Customers with SAS Visual Analytics 8.2 - 2018-01-21
- My 7 Favorite Features in SAS Visual Analytics 8.2 on Viya - 2018-01-14
- Designing Dashboards: Finding the Fantastic Five Colors - 2017-06-19
- Creating a Web Analytics Report in SAS Visual Analytics 8.1 - 2017-06-19