# Table Chart Comparison & Running

### **Comparison Calculations** <a href="#od_6883bdd7" id="od_6883bdd7"></a>

You can include metrics that compare the overall value of a column to each row of your data.

1. In **Columns** section, click the **pen** icon

<figure><img src="/files/9Wv0vDYhQ2PghOmbHI9B" alt="" width="375"><figcaption></figcaption></figure>

1. Click on the down arrow in the **Comparison calculation** field to select the type of comparison calculation you want to use
2. Percent:total - the current row's value divided by the total for that field.
3. Percent:max - the current row's value divided by the maximum value for that field.
4. Diff:total - the total for that field minus the current row's value.
5. Diff:max - the current row's value minus the maximum value for that field.
6. Percent-diff:total - the total for that field minus the current row's value divided by the total for that field.
7. Percent-diff:max - the current row's value minus the maximum value for that field divided by the total for that field.

<figure><img src="/files/yrPesh2Q5GeyvpCdTOqp" alt="" width="375"><figcaption></figcaption></figure>

{% hint style="info" %}
**Another quick way to turn on the running calculations box is click the icon near the header of the table chart**
{% endhint %}

<figure><img src="/files/T3buau4OU85gRxfLiJv7" alt="" width="275"><figcaption></figcaption></figure>

### **Running calculations** <a href="#od_cf3d17cc" id="od_cf3d17cc"></a>

Running computations produce a set of summary outcomes based on a set of data. They produce a result for each row of input, indicating how that row relates to the rest of the collection.

1. In **Columns** section, click the **pen** icon
2. Click on the down arrow in the **Running calculation** field to select the type of comparison calculation you want to use

* Running sum: sum all value from current row up
* Running min: minimum value from current row up
* Running max: maximum value from current row up
* Running count: current row value
* Running average: average value from current row up
* Running delta: value of current row - value of the row above

<figure><img src="/files/zJWvaBRz34z2OUDktyhG" alt="" width="375"><figcaption></figcaption></figure>

{% hint style="info" %}
Another quick way to turn on the running calculations box is click the icon near the header of the table chart
{% endhint %}

<figure><img src="/files/6KARN8EvURLWCOFmbbei" alt="" width="268"><figcaption></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://doc.dataflake.co/drilldowns/table-chart-comparison-and-running.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.