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 |