Charts

Create charts in a story to display your data.

Whether you want to see a visual representation of your data or want to show it to someone else, charts can help you. There are many ways to visualize your data, from bar charts and waterfall charts to tree maps or pie charts.

Once you've picked a chart type, selected your model and added measures and dimensions, you can move onto other tasks such as adding a variance or an axis break, or changing how the data is displayed.

Use the Builder to select the measures and dimensions to include in your chart.

Use the Styling tools to enhance the presentation.

Use the Examine panel to create a table based on the data in your chart.

You can add multiple measures and multiple dimensions to your chart. When measures or dimensions are part of a hierarchy or when a dimension has attributes, you can expand them and select their children or expand a dimension and select its attributes. You can also apply filters to your measures and dimensions. The chart is updated as you make your choices in the Builder.

Tasks – Setting Up Charts

Feature	Description
Creating a Chart	Add a chart to your story or analytic applications page or apply other properties to a chart.
Choosing the Best Chart Type for the Data	When adding a chart to your story or analytic applications page, choose the best chart type for your analysis.
Selecting Measures and Dimensions	After you select a chart type, select the measures and dimensions to display in each area of your chart.
Chart Context Menu Options	There are several features available on the action menu for working with the data in the chart or for changing the chart's appearance.
Styling Options for Charts	Change the look of a chart tile including placement on the page, border format, number formatting, label placement, and so on.
Linking to Another Page, Story, or External URL	Add a hyperlink to another story or page, or to an external URL.

Tasks – Waterfall Charts

Feature	Description
Waterfall Charts	Waterfall charts show how an initial value is affected by a series of intermediate positive or negative values.
Drilling through Waterfall Charts	If hierarchical values are included in a waterfall chart, you can expand or collapse the chart to explore the data at different levels.
Adding a Time-Based Variance to a Waterfall Chart	Add a time-based variance to your chart to show the difference between time periods.

Tasks - Adding Features

Feature	Description
Adding an Axis Break to a Chart	Axis breaks can be used to visually shorten outliers in bar/column or waterfall charts.
Adding Axis Line Breaks to Bubble or Scatterplot Charts	In Bubble or Scatterplot charts, axis line breaks let you remove or reduce visual gaps in the data.
Adding Cross Calculations to Charts	Add a cross calculation to a chart.
Adding Dynamic Text to a Chart Title	Add dynamic text to the chart title or subtitle
Adding an Error Bar to a Chart	Add an error bar to your chart to indicate the error or uncertainty in a reported measurement.
Adding a Footer to a Chart	Add text footers to charts in stories.
Adding a Reference Line	Define reference lines to show important values on your chart; for example, the average and maximum prices of your company's products.
How to Add a Variance to a Chart	Add a variance to your chart to show the difference between versions of a measure or to show the difference between time periods.
Aligning Chart Axes on a Page	A story page is more visually appealing when the chart axes are all aligned vertically and horizontally.
Annotating Data Points	Annotate data points in Bar, Line, and Bubble charts.
Applying a Chart Filter	Exclude non-relevant data points or filter data points to focus a chart on a specific set of data.

Tasks - Different Ways to Display Information

Feature	Description
Break Grouping	When you have multiple dimensions on the categories axis, use Break Grouping to ignore the grouping order and change how the dimensions and measures are sorted.
Displaying the Compound Annual Growth Rate for a Chart	Show the Compound Annual Growth Rate for Bar/Column or Stacked charts.
Displaying Dimension Information in a Chart	In a chart, show the Description, ID, or ID and Description of a dimension.
Displaying Dimension Labels on a Bubble or Scatterplot Chart	Display dimension values on the data-points in a bubble or scatterplot chart.
Displaying the Difference Between Two Data Points	Select two data points in a chart to quickly see the difference between their values. For example, you can compare a year-over-year percentage increase or decrease, or see the delta between two versions.
Showing Unbooked Data in a Chart	Show both booked and unbooked data in a chart.
Zooming in on a Chart	Temporarily magnify a region of a chart.

Tasks - Modifying Chart Contents

Feature	Description
Changing the Hierarchy Level in a Time Series Chart	Change the hierarchy level in a Time Series chart to see the data aggregation at different granularity settings.
Choosing the Measure Order in a Chart	Reorder how measures are displayed in a chart, including displaying them as overlapping bars
Choosing the Version Order in a Chart	Reorder how versions are displayed in a chart. For example, you can display the bars as 1st Forecast, Actual, and 2nd Forecast.
Creating Blended Charts	Create charts with data from multiple models.
Drilling through Hierarchical Data	If hierarchical dimensions are included in a chart, you can drill up or down through dimensions to explore the data at different levels.
Dynamically Set Min or Max on a Chart Axis	Dynamically set the minimum or maximum axis values for all series on a chart axis.
Exporting Data as a CSV File	Export data from your chart or table as a CSV file.
Input Controls: Dimension, Measure, or Cross Calculation	Input controls give you the ability to change which dimensions or measures to display for your charts or tables.
Manually Setting the Axis Range	Manually change the axis range of a chart.
Normalizing a Time Series Chart	Normalize the data in your Time Series chart to compare the relative differences in percentage over time rather than seeing the absolute value of the measure.
Running a Forecast in a Time Series or Line Chart	Run a predictive forecast in time series or line charts.
Scaling Charts	If multiple charts in a story contain the same measure, the measure values may be scaled differently in different charts, which can make comparisons difficult. You can scale the charts so that measures have the same scale across multiple charts.
Sorting Measures and Dimensions	Sort measures and dimensions in charts in ascending or descending order, or you can set your own custom order.
Changing Color Palettes and Synchronizing Colors Across Charts	When the color palette for one chart in a story is changed, all the other charts that have the same color dimension or member will also be updated. This applies to charts that have a single dimension or measure for Color.