Note: Parts of this feature are only available in SharpCloud v9.2.0226 and after.

 

Column views are a classic within SharpCloud and are widely used to display and compare one or more different numeric attributes/properties at either a category level, an item level or an attribute specific level.

 

 

There are 2 types of column charts:

  • Simple – As shown above. Attributes can be selected to have their values displayed at an item level.  In the above image, 4 attribute values are being displayed across 10 items.
  • Grouped – Instead of showing the values at an item level, a grouped chart allows users to group the items by category or attribute.
    • Secondary Chart – When using a grouped chart, users can dive further behind the information by clicking on the bars, revealing a secondary chart showing the items that make up that value (shown below).

 

 

In the above chart, items are grouped by Priority (High, Medium, Low) and totalled by 4 different attribute values (Budget, Cost, Remaining, and Profit). Clicking on any of the bars will show the items that make up its total value on the right. In this example, items with a Priority attribute value of Medium are displayed by Cost value.

 

Note: Only numeric attributes can be visualised in the column view.

 

View Setup

The table below summarises options that are specific to the Column View, which will apply to all chart variants; Simple, Grouped or Secondary.

Setting

Description

Tab

Advanced Toggle Active?

Value

Select the numeric attribute or property to be displayed. More than 1 value can be selected by pressing “Add more values”

Layout

No

Show Bars

Choose either side by side or stacked. Side by side will present the values alongside each other in the order of the values created. Stacked will create a bar with values on top of one another.

Layout

No

Order By

Choose from None (will place items alphabetically), Value Ascending (Lowest to Highest) or Value Descending (Highest to Lowest)

Layout

Yes

Show Labels

Each value of an item can have a label to show the value.

Layout

Yes

Switch fill and border colour

If more than one attribute value is displayed, you will have the option to set the fill colour for your bars. If the attribute has colouring applied (such as red, yellow, green for a status attribute) this will appear as the border colour of your bars. Ticking this box will switch the fill colour with the border colour.

Layout

Yes

Hide empty values

Removes any items that have no values to create a cleaner looking chart

Layout

Yes

Hide Chart Total

The total value of whichever attribute is set for Value 1 will be displayed in the upper right corner of the view by default. Checking this box will hide the total.

Layout

Yes

 

These settings are unique to the Grouped Chart sub-tab:

Setting

Description

Tab

Advanced Toggle Active?

Group By

Select an attribute to group your items by. By default, the items will be grouped by category.

Layout > Grouped Chart

No

Split Bars By

Select any attribute to see your bars split by this value. Note that if you have previously selected multiple values to be displayed, this selection will override those.

Layout > Grouped Chart

No

Show Bars

Choose from Stacked or Side by Side to display your split bars. (If Split Bars By is set to None, this option will have no effect.)

Layout > Grouped Chart

No

 

These settings are unique to the Secondary Chart sub-tab:

Setting

Description

Tab

Advanced Toggle Active?

Background Color

Choose category, any attribute, or a custom color to determine the fill color of the bars when the secondary chart is displayed.

Layout > Secondary Chart

No

Value

Allows a different numeric attribute to be displayed in the secondary chart to the primary chart. By default, it will show the primary chart value

Layout > Secondary Chart

No

Order By

Select any attribute to effectively group your bars by that attribute. Note: Unless your Background Color is set to the same attribute as your Order By field, it may be difficult to see the groupings. 

Layout > Secondary Chart

Yes

Sort Direction

Choose from None (will place items alphabetically), Value Ascending (Lowest to Highest) or Value Descending (Highest to Lowest). Sort is based on the attribute set in Value field.

Layout > Secondary Chart

Yes