Help - Table Of Contents

All the help in one place

 

 

Getting Started

Definitions

The Prism Environment

Tutorials

Connecting to Data   

Connecting to Excel  

Connecting to SQL Server 

Connecting to CSV Files

Connecting to Amazon S3

Working with Pivot Tables  

Working with Charts  

Working with Indicators  

Working with multi-dimensional formulas  

Working with quick time functions  

Building a Basic Dashboard

Distributing Dashboards

 Working with Formulas

Introduction to Formulas

Formula Editing Bar - User Interface

Create and Edit Formulas

Numeric Formulas

Aggregated Dimensions

Aggregation Functions

Time Functions

Range Function

Previous and Next Functions

Date Part Functions

Date Difference Function

ToDate Functions

Quick Time Functions

Growth

Difference

Contribution

Running Sum & Running Average

Rolling Sum and Rolling Average

Filtering and Grouping Members

Introduction to Filters

Filter Editor - User Interface

Using Filters inside the Data Browser

Create and Edit Groups

Create a new Filter from the Data Browser

Edit a Filter from the Data Browser

Filter Types

Filter By Measure

Filter By Label

Filter By Value

Filter By Attribute

Create and Edit Groups

Filter Examples

Filter by Measure and Numeric Value

Using the Scope Popup Window inside the Filter Dialog

Filter by Two Measures

Filter by Multiple Criteria