Self-Service Visualization
  • What is Story?
  • Creating a new Story
    • Accessing the Story Module
    • Create New Story
      • Creating a new Story with an Existing Data Store
        • Creating and Updating Instance
      • Creating a new Story by Uploading a File (CSV/Excel)
      • Creating a new Story based on a Data Sandbox Data Store with Data Preparations
    • Designing a View
    • Saving Multiple Views
  • Design Workspace
    • Dimension Profiling
    • Customized Category Color
    • View Summary
    • Series Properties
      • Conditional Color for Categories
    • Create Calculated Field
      • Creating a Formula
        • Record Level Option
        • Summary Level Option
      • Creating a Range
    • Order by and Limit
    • Adding a Slicer
  • Chart Gallery
    • Mixed chart
    • Area chart
    • Bar chart
    • Bubble chart
    • Column Stack chart
    • Line chart
    • Pie chart
    • Scattered Plot chart
    • TreeMap chart
    • Circumplex chart
    • Pareto chart
    • Semi Gauge
    • KPI Tile
    • KPI Tile: Comparative Tile
    • KPI Tile: Sparkline
    • Map
    • Data Grid
    • Metric Summary
    • Dissolution/Decomposition chart
    • Spider chart
    • Waterfall chart
    • Funnel chart
    • Inverted Funnel chart
    • Heat Map chart
    • Geo chart
  • Storyboard
    • Search
    • Shared Views
    • Live Refresh
    • Export
    • Alert Center
    • Change Theme
    • Data Store Information
    • Options Assigned to a View
      • Analyse
        • Timeline Play
      • Edit
      • Remove
    • Data Interactions/ Data Drills
      • Drill Into
      • Drill Through
  • Applying Filters
    • View Specific Filter
      • Dimension-based View Filter
      • Measure-based View Filter
      • Date-based View Filter
    • Global Filter
      • Exclude from the Global Filter
      • Saving a Global Filter
      • Custom View Filter
      • LOV Settings
  • Interactions
Powered by GitBook
On this page
  • Data Grid
  • Properties
  • General Settings
  • View Filter
  • Category and Series Properties of Grid Chart
  • Re-ordering of Fields in the Grid
  1. Chart Gallery

Data Grid

PreviousMapNextMetric Summary

Last updated 1 year ago

Data Grid

Check out the given walk-through on how to set the Data Grid chart properties.

The users can see data in tabular format by selecting the Data Grid component from the chart list. Multiple values can be displayed via Grid visualization.

Properties

General Settings

  • Order: Users can order the displayed data by selecting an option from the given choices:

    • Ascending

    • Descending

    • None

    • Manual Sort (Users can manually sort the dimensions by using the indicator signs)

      • By selecting an order, the user needs to configure the following fields:

        • Order By- Select a value option from the drop-down menu to order the sequence of the data

        • Limit- Set a number to display the requested information by this limit

  • Font Size: Select a font size out of the given choices (Small, Medium, Large)

  • Bold: Use a checkmark in the box to display the fonts of the heading in Bold

  • Italics: Use a checkmark in the box to apply the Italics style to display the heading

  • Underline: Use a checkmark in the box to underline the headings of the displayed data columns

  • Font Color: Select a font color using the menu

  • Background Color: Select a background color using the menu

  • Exclude from Global Filter: Use a checkmark in the given box to exclude the view from the Global filter condition

View Filter

  • Filter: Select a filter condition from the drop-down menu.

Please Note: The users get redirected to the pop-up colour menu by clicking on Font Colour or Background Colour option.

Category and Series Properties of Grid Chart

The user can set the width of each column by configuring it from the Category Properties (for Dimensions) and Series Properties (for Measures) in the Data Grid.

  • Navigate to a view displaying data in the Data Grid.

  • Adjust the Width field.

  • Select the APPLY option.

  • Adjust the Width field.

  • Select the APPLY option.

Re-ordering of Fields in the Grid

We now support the re-ordering of fields in the Data Grid chart. By allowing field re-ordering, users can present their data in a more logical and meaningful way, improving the overall clarity and usability of the Data Grid chart.

Check-out the given illustration to understand the field re-ordering functionality provided for the Grid chart.

Please Note:

  • Users can only do reordering from dimension to dimension, and measure to measure. Cross-category re-ordering is not supported.

  • User can adjust the size of the Date columns as well.

Properties tab for the Grid charting type
A View displaying data in Data Grid format

Click theicon given for a Dimension to open the Category Properties.

Click theicon given for a Measure to open the Series Properties.

Re-ordering Feilds in the Grid Component