LogoLogo
  • CHARTS USER GUIDE
    • Introduction
    • Angular Gauge Chart
    • Bar/Column Chart
    • Bubble Chart
    • Bullet Chart
    • Calendar Heatmap Chart
    • Column Range Chart
    • Combination Chart
    • Dumbbell Chart
    • Filter Chart
    • Funnel Chart
    • Grid Chart
    • Table heatmap
    • Histogram Chart
    • KPI Animation Chart
    • KPI Ring Chart
    • Line/Area line Chart
    • Mekko Chart
    • Packed Bubble Chart
    • Pie Chart
    • Polar Charts
    • Sankey Chart
    • Simple KPI Chart
    • Slope Chart
    • Sparkline Chart
    • Stacked Column/Bar
    • Text Node
    • Tornado Chart
    • Trellis Chart
    • Variwide Chart
    • Waffle Chart
    • Waterfall Chart
    • Wordcloud Chart
    • Workstation
    • Allow/Block URLs
    • Animation Duration
    • Attribute Forms
    • Auto Scroll
    • Axes
    • Background Images
    • Backward Compatibility
    • Bar/Column Width
    • Color Picker with Opacity
    • Connect Null Points
    • Custom Markers
    • Custom SVG Markers
    • Data Markers
    • Data label customization
    • Dossiers/Documents differences
    • Drilling
    • Error Bars
    • Export to PDF
      • Export engine local resource set up
    • Formatting metric data
    • Gradient Threshold
    • Legend
    • Negative Sign
    • Pattern Fill
    • Play Animation
    • Plot lines/Reference lines
    • Reset color property
    • Reset font properties
    • Right Click Menu
    • Right-to-left Support
    • Series using Attribute
    • Small Multiples
    • Smooth Line
    • Tooltip Customization
    • Tooltip Links
  • GRID/MICROCHART GUIDE
    • Appearance
    • Auto Size
    • Column Totals
    • Context Menu
    • Creating a micro chart
    • Custom markers
    • Custom Editor
    • Filter Data
    • Format/Clear Format
    • Grand Total
    • Pivoting and Row Grouping
    • Horizontal Bars/Pins
    • Embed Images
    • Manage Scaling Grouping
    • Manage Column Grouping
    • Manage Metric Grouping
    • Pin Column
    • Reorder columns
    • Reset Columns
    • Show/Hide Column
    • Sorting
    • Subtotals
    • Thresholds
    • Tooltip
    • Transparency
    • Trend Lines
    • Value Aggregation
    • Variance
  • MAPS USER GUIDE
    • Creating New Maps
    • Custom Layouts
    • Customization of the Map chart
    • Default Maps
    • Formatting Options
    • Generic Merge tool
    • US map using counties data
    • US Map using ZIP Codes
  • IBCS USER GUIDE
    • IBCS
      • Why IBCS
      • Mapping IBCS Scenarios
      • Negative Metrics
      • Scaling Multiple Charts
    • CERTIFIED CHARTS
      • Multi-tier Bar chart
      • Multi-tier Column chart
      • Small Multiples
      • Vertical Waterfall
  • CUSTOMIZATION GUIDE
    • Introduction
    • Custom CSS
    • Custom CSS Samples
    • Custom Color Palette
    • Custom Fonts
    • Condensed Metric Format
    • Disable Edit button
    • Grid Custom CSS
    • Localization
  • FAQ
    • Contact Us
    • FAQS
  • INSTALL DOCS
    • Installing on MicroStrategy Web
    • Installing on MicroStrategy Desktop/Workstation
    • Installing on MicroStrategy Library
    • Installing on MicroStrategy Mobile
    • Release Notes
    • Release Notes Maps
Powered by GitBook
On this page
  • Properties Menu - Sorting
  • Advanced Sorting
  • Advanced Sorting using Edit Option
  • Advanced Sorting using the Hamburger option
  • Advanced Sorting using Right Click properties
  • Advanced Sorting on Grouping Level
  • Sorting based on attribute forms in the Vitara Grid chart

Was this helpful?

  1. GRID/MICROCHART GUIDE

Sorting

PreviousShow/Hide ColumnNextSubtotals

Last updated 7 months ago

Was this helpful?

Properties Menu - Sorting

In Vitara Grid chart with just a click on the header of a column, we can sort the data in that column. For the first click on the column header, representing the column is sorted into ascending order. See the screenshot below which is in Ascending order.

If we want to sort the column in descending order, click a second time on the column header. representing the column is sorted in descending order.

Sorting can be removed by clicking on the column header for the third time. We can also sort multiple columns by holding the ‘shift’ button on your keyboard click on all the column headers which you want to sort.

Advanced Sorting

Advance sorting will allow users to do different sorting on different grouping levels. By this, you can easily sort the columns in your required order. The Property editor has an option of Sorting. See the below-representing sorting option in 3 different ways.

Advanced Sorting using Edit Option

From the Property Editor, click the Sorting tab. The first one square button shows the metrics you want to sort and the second one shows the order what you want to sort. See the screenshot below.

Advanced Sorting using the Hamburger option

From the Hamburger menu, Select any metric, select Advanced Sorting and click on Manage Sorting, it will take you to the Editor tab. See the screenshot below.

Advanced Sorting using Right Click properties

From the Right Click Menu, Select Advanced Sorting then click on Manage Sorting you can able to apply to sort in the Property editor window. See the screenshot below.

Advanced Sorting on Grouping Level

Advanced Sorting can be applied on grouping levels too. Now, once grouping is applied in the grid, there is a button added in the property editor. See the screenshot below where the Sorting is applied on a discount on a product category level.

Sorting based on attribute forms in the Vitara Grid chart

From the 4.3 release, Vitara chart supports multiple attribute forms. In the normal XY charts multiple attribute forms are concatenated and in the grid and micro charts each attribute form will be shown as separate column.

In the below screenshot, for the attribute “Customer” the attribute forms “Customer First Name” and the “Customer Last Name” are enabled.

As shown in the above screenshot, each attribute form will be displayed as a separate column in the Vitara grid chart. We can sort the Vitara grid based on a particular attribute form. Open Vitara properties window by clicking on the “Edit’ button. Open “Advanced Sorting” menu. In the advanced sorting window we can select the attribute form on which we want to sort the grid chart.

In this example I selected the attribute form “Customer First Name” to sort the grid chart.

If we don’t want to display the attribute form on which we applied sorting we can hide that attribute form. Open “Show/Hide Columns” menu and uncheck the attribute form/attribute you don’t want display in the chart.

Below is the result of Vitara grid chart, in which we enabled two attribute forms “Customer First Name” and “Customer Last Name” and the chart is sorted based on the attribute form “Customer First Name” and finally the attribute form “Customer First Name” is not showing in the chart.