COST ANALYSIS

By default the app consider more "better", and therefore plots positive variances in green and negative variances in red. Positive variances of discounts and of COGS will be plotted red.

If you are analyzing cost rather than revenue data you need to modify the default behavior. Simply set the Variance🚦widget to 🟢-🔴+ (less is good, more is bad) instead of the default 🔴-🟢+ (less is bad, more is good).

The charts will show positive variances in red and the metric will automatically be shown as "Costs" instead of "Sales"

If the dataset does not contain quantity information variance will be computed as an aggregate.

COST ANALYSIS EXAMPLE

As an example we have loaded NYC budget example dataset on the site. If we run a "a variable dimension" bridge with standard parameters, we get this. Notice that the most important items is "N/A" as Responsibility Center Name. The field seems to be often empty.

Lets drop the responsibility center name column from our analysis

Here is the new output.

We are showing this chart with the initial and final totals. You can also see it without by changing the wizard below.

Here is the result

We want to understand better that first "Contractual services" row so we drill down

The app now also returns a more detailed report.