Data bars are use to make "Tornado charts" in order to get an idea as how values are distributed.
We will use the same data source tbl_Players for this demonstration too.
Objective
In this experiment, we will see how the players runs are distributed using Data Bar.
DataBar into action
In the design view, add a table with three columns. In the first column, let us add [Player Name] field while in the last two column let us add the [Runs Made] column. Let us rename the header of the third column to [Runs Analysis]
From the Report Item toolbox, let us drag and drop a Data Bar control on to the third column. The Data Bar Type properties window appears. From there let us choose the "Stacked bar" Data Bar type
And click OK. Right click on the Data Bar and from the context menu, choose Chart Properties
In the General section of the Chart Properties window, choose Gray Scale from the Color Pallet drop down.
And in the Fill section, choose Gradient in the Fill Style and provide some suitable gradients
Click OK and view the report
We can reverse the direction of the Data Bars. Right click on the Data Bar and from the context menu,choose Horizontal Axis Properties.From the properties dialog check the Reverse Direction checkbox of the Scale options.
The report is as under
Subscribe to:
Post Comments (Atom)
SSIS: Creating Package Configurations
This post discusses the creation of Configuration Files and how they can be useful while migrating a package from one environment to an...
-
Synchronous vs Asynchronous The SSIS dataflow contain three types of transformations. They can be non-blocking, semi-blocking or ful...
-
The below are the differences between systems. Please go through them. . OLTP ...
-
1. How to provide security for the configuration file (xml package configuration file)? 2. Different approaches of deployme...
No comments:
Post a Comment