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
  • Custom Editor
  • 1. Keyboard Shortcut:
  • 2. Using the Hamburger Menu:
  • Custom Editor Overview
  • Tabs for Formatting:
  • Column Content Tab:
  • Header Content Tab:
  • Custom Editor Menu:
  • Images:
  • Links:
  • Table Menu:
  • Format Menu:
  • Toolbox Panel:
  • Inserting Elements:
  • Applying and Exiting
  • Creating Metric/Attribute Groups
  • Using Macros in the URL Link of the Custom Editor
  • Why Use Macros in URL Links?
  • Key Benefits:
  • Implementing Macros in URL Links

Was this helpful?

  1. GRID/MICROCHART GUIDE

Custom Editor

PreviousCustom markersNextFilter Data

Last updated 3 months ago

Was this helpful?

Custom Editor

Welcome to the documentation for the latest feature in the grid chart software, version 5.2. This exciting update empowers users with enhanced chart personalization capabilities, allowing them to tailor their charts to their specific preferences. This guide will walk you through the various steps and options available in this new feature. Enabling Customization To get started with the customization function, follow these steps:

1. Keyboard Shortcut:

Hold down the “Ctrl” key on your keyboard and left-click on any metric or attribute header to activate the customization feature.

2. Using the Hamburger Menu:

Alternatively, access the hamburger menu and choose the “Format” button. This will also open the custom editor.

Custom Editor Overview

Once the custom editor is enabled, the custom editor will be your tool for making changes.Below is an illustration of how the custom editor looks when launched.

Tabs for Formatting:

Column Content Tab:

Apply formatting to the content area of a selected element’s corresponding column (attribute or metric). Changes are displayed within the column’s content.

Header Content Tab:

Apply formatting to the header of a selected element’s corresponding column. Changes are reflected in the column header.

Custom Editor Menu:

Below the tabs, you’ll find the “Custom Editor Menu.” This menu offers a range of customization options:

Images:

To add photos to the chart, use the “Insert” property tab. This brings up a new pop-up menu where we can add the picture and URL to the Source field box and adjust the width and height to make it visible within the grid.

Links:

To add URL links to an attribute or metric, select the “Insert” property tab. This brings up a new pop-up menu where we can choose the link we want to add, give it a name using the title property, and choose whether to open the link in a new tab or the same window as it is currently open.

To unlink the set link right click on the added link and click the remove link option.

Table Menu:

Imagine that we are designing a sales analytics dashboard with a customized editor’s table displaying data on product sales. The typical data columns (Product Name, Units Sold, Revenue, etc.) should still be included, but you also want to include more in-depth breakdowns using tabular data in specific cells.

To add tables to the chart, go to the “Insert” tab and arrange the rows and columns to build a table. Then, in each cell, we can fill it with macros of our choosing to be displayed on the grid.

Furthermore, we can individually customize each cell individually by going to that specific cell and then right clicking to open a menu where we can further customize the cell properties and set border color, style, width, and similar for the table properties.

We can also add, merge and delete row/columns from table itself with the below table property

Format Menu:

Assume you’re creating a financial performance dashboard to display quarterly sales statistics. Instead of presenting plain numbers, you decide to use Grid’s versatility and the formatting features of the custom editor to improve data clarity and presentation.

The format box provides an abundance of options, including bold, italics, underlining, strikethrough, superscript, subscript, and various formatting options. alignments, font sizes, line height, background color, and many others.

To apply the formatting head to the metric/attribute where we want to make formatting and select the formatting and hit submit button to apply changes.

Toolbox Panel:

The toolbox panel is situated below the custom editor menu. It provides convenient buttons for quick text adjustments, eliminating the need to navigate menus.

Inserting Elements:

The custom editor empowers you to insert various elements into your chart: Emojis: Add a touch of emotion to your chart.

Undo & Redo: To restore or revert the performed actions.

Formatting: Applying formatting like Bold, Italic and text color, Background, Size and font.

Tables: Organize data effectively.

Applying and Exiting

After making the desired formatting and modifications, simply hit the “Submit” button to see the changes take effect. To exit the custom editor, click anywhere on the grid chart. This will return you to the default view.

Creating Metric/Attribute Groups

To group metrics or attributes, follow these steps:

1. Selection:

Hold down the “Ctrl” key on your keyboard.

2. Grouping:

Left-click on the metric or attribute headers you want to group.

3. Column Grouping Button:

In the custom editor, you’ll find the “Column Grouping” button. Clicking it will create the group for you.

Using Macros in the URL Link of the Custom Editor

The Grid Chart allows users to define custom links using macros, enabling dynamic URL generation based on attribute elements. This feature enhances interactivity by allowing seamless navigation to web pages.

Why Use Macros in URL Links?

In today's data-driven world, effective visualization is essential for informed decision-making. The Grid Chart provides a structured way to display data, but integrating macros into the URL link within the custom editor enhances interactivity and usability.

Key Benefits:

Dynamic Content: Macros allow the URL to change based on the data being displayed, ensuring that each user interacts with content that is relevant to them.By incorporating macros, you can customize URL links using specific data points from the Grid Chart.

Improved User Experience: By linking to customized URLs, users can access specific information or actions with a single click, saving time.

Enhanced Tracking: Incorporating macros can help in tracking user interactions more effectively, providing valuable insights into user behavior.

Implementing Macros in URL Links

Syntax and Structure: To use a macro, you need to follow a specific syntax. Typically, this involves enclosing the macro name in braces

.For example, &[macroName]. Example Usage: For instance, if you want to link to a web page, your URL might look like :”https://www.google.com/search?q=&[Category]”

To add this URL link to an attribute or metric, select the “Insert” property tab. This brings up a new pop-up menu where we can choose the link we want to add, give it a name using the title property, and choose whether to open the link in a new tab or the same window as it is currently open.

Please refer to the attached GIF file for reference.

.Incorporating macros enhances the functionality of your custom editor and improves user experience in navigating the Grid Chart.

With these instructions, you’re ready to dive into the exciting new world of version 5.2’s grid chart customization. Enjoy tailoring your charts to perfection!