Add table to a dashboard

This discussion was created from comments split from: How do I pull in a table into a Dashboard?.

Answers

  • JAAS
    JAAS
    edited 02/03/25

    I want to add this to a dashboard - it's part of a calculation sheet I use to create other charts from many sources. The below totals data from many sheets and cannot be done via a report, I require it as is, yet dynamic like other widgets.

    Header 0

    Header 1

    Header 2

    Header 3

    Header 3

    Header 5

    NAME

    0

    3

    4

    0

    0

    NAME

    0

    6

    22

    0

    0

    NAME

    0

    3

    46

    22

    7

    NAME

    0

    1

    1

    0

    0

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

    etc

  • John_Foster
    John_Foster Community Champion

    @JAAS

    Try creating a report to show this data. Report can be a table view and reports display as you would like on the dashboard.

    Thanks,
    John

  • I have a data calculation sheet with 9 different tables from 7 sheets, and I want to display data from 1 of these in a table, the others work well as pie and bar charts. This 1 table does not work well as the widgets are rudimentary. I tried to make this set of data into a separate report table, and it pulls in all of the other data in from the sheet. I cannot hide rows to isolate just what I want to show, so it's not working.