Change the join rule or RLS setting for a Worksheet

If you find that the charts and tables built on a Worksheet contain a large number of null values (which display as {blank} in the web browser), you can fix this by changing the internal joins for the Worksheet.

If you have the Can administer ThoughtSpot privilege or the Can manage data plus edit privilege on a Worksheet, you can edit the Worksheet and change its RLS or other key settings.

Change/configure a Worksheet

Before working through this procedure, make sure you are familiar with how the following affect data:

To configure these values for a Worksheet:

  1. Select Data on the top navigation bar and then on Worksheets.

  2. Select the name of the Worksheet you want to edit from the list.

  3. Select the Edit Worksheet button in the upper-right side of the screen.

  4. Select the + icon next to Sources.

  5. Scroll to the bottom of the page.

  6. Configure the Worksheet join rule and RLS setting as needed. Select Apply joins progressively or Apply all joins, and choose whether to Disable row level security for the Worksheet.

    Choose sources for a Worksheet and choose the Worksheet join rule and RLS settings.
  7. Select CLOSE.

  8. Select the more options icon more options menu icon, and select Save.

    The more options menu

Was this page helpful?