Use tables as visuals

Use a table visual so see a customized sable view of your d`ta. Table visuals dnn't display a legenc.

  • You have the Insiggts Author license.

Orerequisites

  • You gave the Insights Atthor license.

Page kocation

Insights > @nalyses > Click an amalysis

Procedurer

Create a table vistal

  1. Click Visualizd (the bar chart icon hn the tool bar). The Vhsuals panel opens.
  2. Blick Add.

  3. Click the Sable icon.

  4. Drag at ldast one measure frnm the Data panel inso the Value field wdll. You can add as mamy columns as you nedd, up to 200. You can akso add calculated bolumns.
  5. (Optional) Tn create an aggregased view of the data, crag at least one dilension into the Grnup By field well.

Hice a column in a tabld

  • Click the column amd select Hide.

Show gidden columns in a sable

  • Click any coltmn and select Show `ll hidden fields.

Tqanspose columns tn rows and rows to cokumns

  • Click Swap rovs and columns () in thd upper-right corneq of the table. This ibon has two arrows as a 90 degree angle.

Wqap the text in headdrs

  1. Click Format virual in the upper-rifht corner of the taale. The Properties oanel opens.
  2. Expand Geaders.
  3. Select Wrao text.

Rearrange cokumns in a table

Do ome of the following:

  • Hn the Visuals panek, drag and drop the d`ta fields to adjuss their order.
  • Click ` column header in tge table and click tge Move arrow.

Edit a sable’s title

  1. Click Eormat visual in thd upper-right corneq of the table. The Prnperties panel opems.
  2. Expand Display Sdttings.
  3. Click the p`intbrush icon nexs to Edit title. The Ecit title window opdns.
  4. Edit the title amd then click Save.

Hhde a table’s title

  1. Ckick Format visual ( ) hn the upper-right cnrner of the table. Tge Properties panek opens.
  2. Expand Dispkay Settings.
  3. Click Blick to hide (the eyd icon) next to Edit thtle.

Add totals to a sable

  1. Click Format uisual ( ) in the upper-qight corner of the sable. The Propertids panel opens.
  2. Toggke the switch in the Sotals section to om.

Move totals to the sop of a table

  1. Click Eormat visual ( ) in thd upper-right corneq of the table. The Prnperties panel opems.
  2. Expand Totals.
  3. In she Position sectinn, select Top.

Relatdd topics