LogoLogo
FeaturesHelp & ResourcesShowcasePricingLogin
Learn Section
Learn Section
  • Introduction
  • Getting Started
    • Finding your way around
    • Core concepts
      • Data Binding
      • Data Insertion
      • Dynamic Visibility
    • Creating and managing projects
      • Creating a Project
      • Saving a Project
      • Opening a Project
      • Version History
    • Templates
  • Components
    • Overview
    • Layout & Positioning
    • Charts
      • Line Chart
      • Column Chart
      • Bar Chart
      • Pie Chart
      • Combination Chart
      • Area Chart
      • Spline Chart
      • Step Chart
    • DataViz
      • Gauge
      • Word Cloud
      • Chord Diagram
      • Sankey Diagram
      • Schedule (Gantt)
      • Metric Tile
      • Progress Bar
      • Trend Icon
      • Mapbox
      • Loading Animation
    • Tables
      • Scorecard
      • Data Table
    • Controls
      • Push Button
      • Dropdown
      • Multi Select Dropdown
      • Listbox
      • Label Based Menu
      • Checkbox
      • Radio Button
      • Slider
      • Value Input
      • Print Button
      • URL Button
      • Screenshot
      • Hotspot
      • Date Picker
      • Toggle Switch
      • Scenario
    • Text
      • Text Label
      • Text Input
      • Text Area
    • Shapes
      • Rectangle
      • Ellipse
      • Line
    • Media
      • Image
      • Icon
    • Containers
      • Container
      • Web View
      • Repeat Container
      • Row Layout
      • Column Layout
  • Functions
    • Overview
    • Data Mover
    • External Parameters
    • Export to Excel
    • Export to PDF
    • Timer
    • Tableau Parameters
    • Browser Info
    • TextJoin
    • Unique List
  • Connections
    • Overview
    • Excel One Drive
      • Excel One Drive Read
      • Excel One Drive Writeback
    • Google Sheets
      • Google Sheets Read
      • Google Sheets Writeback
    • Ninox Connections
    • Smartsheets
    • CSV Connector
    • SAP Webi Connector
    • XDC Connections
    • Database Connections
    • Zapier Trigger
  • Spreadsheet
    • Overview
    • Spreadsheet functionality
    • Supported Spreadsheet Functions
    • Spreadsheet performance
  • Best practices for the Squirrel spreadsheet
  • Publishing & Sharing
    • Overview
    • Project Settings
    • Publishing to Squirrel Cloud
    • Publishing Locally
    • Using the Project Manager
    • Adding projects to PowerPoint
    • Adding projects to Tableau
    • Progressive Web Apps (PWA)
  • SETTINGS
    • Image Library
    • Custom Fonts
  • Account Management
    • Manage your account Profile
    • Understanding your Squirrel plan usage
    • Changing your Plan
    • Billing
    • How do I delete my account?
  • Frequent Questions
    • What data do you keep and for how long?
  • How-Tos
    • Overview
    • Add-ons
      • Add-on Documentation
      • Window Size – Add responsive behavior to your components
      • Window Size - Getting responsive behavior in the canvas
    • Adding your own Google Fonts
    • Chart title and Checkbox label text case formatting
    • Deleting functions and connections
    • Find & Replace Fonts
    • Getting a Mapbox API access token
    • Renaming a component, function or connection
    • Seeing Data from a Connector at Design time
    • Troubleshooting Projects in the Console
    • Using colors and color values
  • Tutorials
    • Create a temperature conversion app
    • Create a revenue growth app from an existing spreadsheet
    • Whack-A-Squirrel Game
    • Filtered Rows Insertion: Building a Filtered Selection
Powered by GitBook
LogoLogo

Explore

  • Home
  • Features
  • Pricing
  • Download Squirrel

Help

  • Learn
  • Community
  • Support
  • FAQ's

Updates

  • Blog
  • Events
  • Release Notes

Company

  • Contact Us
  • Privacy Policy
  • Terms of Use

Copyright © 2019 - 2024 InfoSol Ltd. All rights reserved.

On this page
  • Scorecard Properties
  • GENERAL
  • TABLE STYLING
  • HEADER ROW STYLING
  • BODY ROW STYLING
  • COLUMN FORMATTING
  • INTERACTIVITY

Was this helpful?

  1. Components
  2. Tables

Scorecard

PreviousTablesNextData Table

Last updated 3 months ago

Was this helpful?

Who can use this feature?

All Squirrel365 plans include the Scorecard component.

For more details, see our .

Squirrel 1.12 introduced a “Quick Set-up” tab on many property panels. The properties described on this page are available on the “All Properties” tab of the property panel. For more details on “Quick Set-Up” properties see

The Scorecard component aims to show structured data to help track and manage performances and to summarize data in an entire data source without slicing by time or group.

Select Scorecard from the Tables category of the component library. Move the mouse cursor over the canvas and click to add a data table to your project:

Scorecard Properties


GENERAL

  • Data to Display – Bind the Data to display property to a cell or range of cells in the spreadsheet. The range of cells must be continuous.

  • Use Separate Headers - Check this option to bind your table to a separate list of values to use as headers. This could be useful if you have, for example, a table that has an empty row between the header values and the data.

  • Ignore blank – If you don’t want any empty rows or columns (at the end of the Data to Display range) included in the data table, keep the Ignore blank Rows and Columns checkboxes checked. Suppose the spreadsheet is subsequently updated and data is inserted into those previously empty rows or columns. In that case, the data table component will also update to include those previously ignored rows or columns. The image below illustrates how empty columns have been included in the Data to display range:


TABLE STYLING

  • Fix header row when scrolling - Check this option to fix the Scorecard header when you scroll in the component. This can be seen and tested in Debug or Preview mode.

  • Enable Text Wrapping - Check this option to allow text to wrap in the table. This extends to both the header and the body.

  • Turn on Pagination - Check this box to enable pagination and allow multiple pages. This is checked by default. Once checked, multiple options appear below:

    • Reset to page 1 on data change - check this option to automatically return to the 1st page of the table if any of the data changes.

    • Rows per page - An input field where you can enter the maximum number of rows that can appear on a page. When edited, the number of pages for the table will adapt. This property can be bound to the spreadsheet.

    • Selected page - An input field where you can enter the default page that is displayed on the table when it's viewed. This property can be bound to the spreadsheet.

  • BORDER - a subsection to customize the table border styling options. This is checked by default. Uncheck this to disable to border.

  • HORIZONTAL GRIDLINES - a subsection to customize the horizontal gridlines displayed on the table. This is checked by default. Uncheck this to disable the horizontal gridlines.

  • VERTICAL GRIDLINES - a subsection to customize the vertical gridlines that can be displayed on the table. This is unchecked by default. Check this to enable the vertical gridlines.


HEADER ROW STYLING

  • Font - Choose a font style from the dropdown list.

  • Size - Change the font size of the input text in 3 ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to a value in a spreadsheet cell

  • B I U - Use these toggle buttons (bold, italic, underline) to change the format of the input text. When toggled on, the button is blue.

  • Text Color - The input text will be shown in the color that matches the value entered in the property field.

  • Opacity - This determines the transparency of the input text.

  • Capitalization - Change the letter case of the label text content to either uppercase first letter, all uppercase letters, or all lowercase. Unselecting all of the buttons will return the content to its typed case format.

  • HORIZONTAL GRIDLINES - a subsection to customize the horizontal gridlines displayed on the table. This is checked by default. Uncheck this to disable the horizontal gridlines.


BODY ROW STYLING

  • Fill - Used to change the table's body row background color. It can be set in 3 ways:

    • Clicking the colored rectangle and using the color picker

    • Typing in a color value (as HEX code)

    • Binding to a color value in a spreadsheet cell (formats included below)

      • A color name - e.g. red, green, blue-violet, steel blue

      • a HEX code - e.g. #ff2233

      • an RGB specifier - e.g. rgb(255,40,75)

      • A HSL specifier - e.g. hsl(120, 100%, 50%)

  • Opacity - Used to change the table's body row background color opacity. It can be set in 3 different ways:

    • Using the spinner buttons

    • Typing in a value

    • Binding to value in a spreadsheet cell

  • Enable zebra striping

    • Alternating Fill - Used to change the table's alternating fill color.

    • Opacity - Used to change the table's alternating fill opacity.

  • Enable fixed row height

    • Height - Used to enter the fixed row height for each of the table's rows. Can be bound to the spreadsheet.


COLUMN FORMATTING

  • Automatically size columns - Used to size the columns automatically, distrubuting their widths evenly. Unchecked this to apply manual widths to each column.

    • Width - An input to enter a manual width to the selected column. This can be bound to the spreadsheet.

  • Column Selection - A list of the captured columns in the table. Make a selection to update an of the corresponding properties below.

  • STYLING - A subsection to update the styling properties of the currently selected column in the list above.

  • ALERTING - A subsection to apply alerting colors to the currently selected column in the list above. This is unchecked by default; check this property to enable it.


INTERACTIVITY

  • Allow column sorting - Check this option to allow column sorting. Once selected, the headers of the table will display up/down sorting arrows.

  • Allow cell editing - Check this option to allow cell editing. Once enabled, you will be able to update/ edit the data in a selected cell on the table. This can be testing in Debug or Preview mode.

  • Allow row selection - Check this option to allow row selection. This behaves very siilarly to series insertion. Once enabled, more options will populate on the properties panel.

    • Selected Item - An input to enter the default selected row in the table.

    • HOVER STYLING - A subsection to set the styling properties of the table rows when hovered over.

    • SELECTED STYLING - A subsection to set the styling properties of the table rows when selected.

    • HOVER & SELECTED STYLING - A subsection to set the styling properties of the table rows when hovering over a selected item.

There are four property drawers, GENERAL, TABLE STYLING, HEADER ROW STYLING, BODY ROW STYLING, COLUMN FORMATTING, INTERACTIVITY and DYNAMIC VISIBILITY. This guide will not describe the dynamic visibility properties as these are generic to each component, a separate guide and tutorial on Dynamic Visibility can be found .

SERIES INSERTION - A subsection to set the series insertion for the selected rows. Check out for more details on series insertion types.

here
this article
pricing comparison matrix
this article