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.



(info) 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 ...

    • DBSCAN

      DBSCAN is located under Machine Learning ( ) in Anomaly Detection, in the left task pane. Use the drag-and-drop method to use the algorithm on the canvas. Click the algorithm to view and select different properties for analysis. Refer to Properties ...

    • Top N Bottom N

      The Top N/Bottom N refers to the top (highest/largest) N values and bottom (lowest/smallest) N values or ranks in the aggregated values of the selected measure in the dataset. For example, if N = 15, then corresponding to a particular variable, we ...