Take a tour of Flexible Variance mode
Last updated
Was this helpful?
Last updated
Was this helpful?
While Flexible Variance mode might look slightly different from the other modes at first glance, its basic layout is the same: the toolbar along the top, dimensions on the left, and the grid in the center. It has many of the features you're familiar with in the other Analytics modes, along with some of its own.
The toolbar at the top has menus you use to change your view of the data, as well as some other tools.
Mode: This menu lets you change the mode, which is a pre-defined view of data that displays particular columns in the grid. Currently, Other modes is the only option in the menu, and it takes you back to the previous mode you were on.
Properties: This menu lets you (information stored about a dimension) displayed in the grid.
Stream: This menu lets you (series of data in the underlying database) displayed in the grid.
Measure: This menu lets you (numerical data) displayed in the grid. The Count option allows you to replace the displayed measure value with the relative count of items in a specific dimension.
Period 1, Period 2, and Period (breakdown): Similar to the menu that lets you (timeframe) that applies to the data in the grid, these menus are the foundation of Flexible Variance mode. Firstly, select any two periods to compare and calculate the variance in the grid. You're not restricted to a current and previous period. Then select one of those periods (or another period) to add the applicable period columns to the grid. You then get a breakdown of the data for detailed analysis, allowing you to see if it’s trending in the right direction.
Save as favorite: .
Sparklines: By default, sparklines display in the Total column of the Breakdown column group, which is a group of repeated columns. Repeated columns have the same structure (same stream, measure, and period), making them a great candidate for sparklines. The sparklines illustrate the trends over the period in a graphical format allowing you to identify changes at a glance. For example, a sharp decrease in the sparkline might signal a drop in sales, something worth investigating. If you don't want to see the sparklines in the grid, click the Sparklines button to remove them.
Chart builder: Open the chart builder tool to .
You can take some actions with these columns and add your own custom columns. See .
Some columns in the grid have a context menu that displays when you right-click a cell in the column. This is a handy way to do an advanced filter based on a condition directly from the grid. See .
Chart view: Click this tab to view pre-built charts that allow you to visualize the data in the grid. These charts were created by Phocas for displaying the data in this particular mode. They save you time, as you don't need to create them yourself. It is possible for you to and add them to this tab.
Transaction view: Click this tab to view the list of transactions that make up the data you see in the Grid view tab. The purpose of this tab is similar to the that's available with the other modes, but instead of having to open another mode to view the underlying transactions, you can see them right here within the same mode.