How to display all the data from a cell value which contains sub-rows or rows within a row.

How to display all the data from a cell value which contains sub-rows or rows within a row.

book

Article ID: KB0076771

calendar_today

Updated On:

Products Versions
Spotfire Analyst 7.5 and Higher

Description

For a table visualization, there can be a scenario where we have rows within a row and in that case only the topmost row within that cell is displayed. This article describes how we can display all the sub rows within a cell value.
 

Environment

All Supported Operating Systems

Resolution

Go to Properties >> Appearance >> Data rows height (number of lines) >> Increase it to a suitable height such that all the sub-rows are displayed (By default it is set to one because of which all the sub rows are not visible).

Please refer to the attached GIF below

User-added image

NOTE: This setting is evenly applied for all the rows and so there can be empty spaces where sub-rows are less or absent.
 

Issue/Introduction

How to display all the data from a cell value which contains sub-rows or rows within a row.