Merge Same Values

Merge Same Values

The Merge same values option allows you to merge rows containing same values for the selected dimension.
This option is available under Column option in Table, Cross Table, and Sparkline charts and is visible only after you select a column.



 Note:

This functionality works only when same values occur in consecutive rows.


To use Merge same values formatting options, first plot a Table or Cross Table chart using the measures from the dataset. For example, we plot a Table Chart of Region and Item.

The figure given below shows an original image of the Table Chart.



Now,

  • Select Region column
  • Turn the Merge same values toggle ON

The resultant widget is shown below.



    • Related Articles

    • Values

      Values formatting option is available in the Cross Table widget. The table given below describes different fields present on Values formatting. Field Description Remark Header Font It allows you to change the appearance of the Header row. You can ...

    • Data Merge

      Data Merge is located under Model Studio ( ) in Data Preparation, in the task pane on the left. Use drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Properties of Data ...

    • Data Merge

      Data Merge is located under Model Studio ( ) in Data Preparation, in the task pane on the left. Use drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Properties of Data ...

    • Highlight- Hide Values Support

      The option Hide Values, is available to configure highlighting with or without showing data values. This option is available in Highlight configuration for Table, Sparkline and Cross Table. When data values are hidden, the Style Icon is shown or ...

    • Setting Variable Values from Scheduled Pipeline Execution

      This functionality allows users to assign specific values to pipeline variables at the schedule level. When a pipeline runs through a schedule, the variable values defined in that schedule override the global variable values. This enables dynamic, ...