![Score Cards](https://app.chatwoot.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBCTDNqekFVPSIsImV4cCI6bnVsbCwicHVyIjoiYmxvYl9pZCJ9fQ==--1884ce56af48c3cb9baf026f8e0f6de77c266898/Screen+Shot+2025-02-19+at+8_46_34+AM.png?cw_image_width=2092px)

\
A scorecard is a valuable chart for measuring and tracking performance against specific goals, whether in business, project management, or personal development. It provides a clear framework for assessing progress by using key performance indicators (KPIs) or predefined criteria. By offering a visual and structured way to evaluate success, a scorecard enables informed decision-making, continuous improvement, and goal achievement.

---

# Create a Chart

![Create a new chart](https://app.chatwoot.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBCTUhqekFVPSIsImV4cCI6bnVsbCwicHVyIjoiYmxvYl9pZCJ9fQ==--fa7e53ff6dce9060cb0e2d78f49e2029fd05167d/create+new+chart.gif?cw_image_width=1800px)

## Steps

1. Within the table, click on the "+" sign above the search bar.

2. From the drop-down menu, select **Chart view**.

3. A box will appear to enter a name for the view—choose a **descriptive name** that reflects its content.

4. **Select who can edit:**

   * **Collaborative** for team access and editing.

   * **Personal** for individual use. **note: you can't add it in dashboards**

5. Click "Add".

6. Click Chart type .

7. from the list Choose **Score Card** Chart.

# **Build a Score Card Chart**

![How to Build a Score Card Chart](https://app.chatwoot.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBCTC9qekFVPSIsImV4cCI6bnVsbCwicHVyIjoiYmxvYl9pZCJ9fQ==--14131c02e729aa0cab3737956fe2e34cfd641ad3/budget.gif?cw_image_width=1800px)

1. **Choose X-Axis:** Select a column from the drop-down list to define the **measured** variable for the chart.

2. **Choose a Measure:** Once a column is selected, choose the appropriate measure to apply.

   **Dynamic Measures:** The available measures will be automatically populated based on the selected column type, ensuring relevant calculations and insights.

3. Add **Sub-Header** (**optional**): write a description for KPI, as it helps break up content, making it easier to read and understand.

## **Score Cards Setup:**

![](https://app.chatwoot.com/rails/active_storage/blobs/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBCTHpqekFVPSIsImV4cCI6bnVsbCwicHVyIjoiYmxvYl9pZCJ9fQ==--d4c3956ab96eec3c4c3b569c46a7e7182e8e0073/score+card.png?cw_image_width=2722px)

<!--cw-colwidths:170,0-->
| Color          | Purpose                                                                                                                            |
| -------------- | ---------------------------------------------------------------------------------------------------------------------------------- |
| 🔴 X-Axis      | a drop-down list consist of columns of the table.                                                                                  |
| 🟢 Measures    | available measures will be automatically populated based on the selected column type, ensuring relevant calculations and insights. |
| 🔵 Sub-headers | helps break up content, making it easier to read and understand.                                                                   |
| 🟠 Currency    | Currencies and Number format always follow the column setup within the table.                                                      |

## **Available Measures Based on Column Types:**

* **Numbers:**

  * **Count** – Counts the number of entries in the selected column.

  * **Sum** – Adds up all numerical values.

  * **Avg** – Calculates the average of the values.

  * **Min/Max** – Retrieves the minimum or maximum value in the dataset.

* **Other Column Types:**

  * **Count ONLY** – Non-numeric columns can only be counted.

| Numbers formats always follow the column setup within the table. |
| ---------------------------------------------------------------- |

## **Examples:**

* If you want to **calculate the total number of projects**, you can select the project id column and apply the **Count** measure.

* If you need to **analyze a project budget**, you can choose the budget column and apply **Sum, Average, Min, or Max** as needed.

---

# How to Filter a Score Card

Within the view, click on the **funnel icon** in the view bar.

1. A box will appear; click on **"Add filter."**

2. Three fields will be displayed:

   * **Choose a Column**

   * **Choose a Condition**

   * **Choose a Value to Filter by**

The filter will be applied directly to the view, updating the displayed data based on the selected criteria.

Example:\
you can filter ONLY Completed Projects. but don't forget to add sub-header to explain the filtered data.

---

# Fields Availability

If certain fields don’t appear in the list when creating charts, it's because some field types are not supported for visualization on both the x-axis and y-axis. These include:

* **Long text**: Typically not suitable for numerical or categorical representation in charts.

* **File**: Contains attachments or documents, which cannot be plotted on a chart.

* **Multiple select**: Stores multiple values, making it difficult to plot in a single axis format.

* **Collaborator**: Represents users rather than measurable data.

* **Link to table**: References another table instead of containing direct numerical or categorical data.

* **Lookup**: Pulls values from another table but isn’t always structured for charting.

* **Formula containing lookup output**: Derived data that depends on lookups, which may not be supported in chart rendering.

* **AI**: AI-generated outputs may be complex and not directly usable in charts.

* **Formula containing AI output**: Similar to AI fields, these often contain generated text or complex logic not suited for visualization.

These limitations exist to ensure that only structured, quantifiable data is used for meaningful chart representation.