Table Visualizations with Time Comparison Data

[Yisel-Ulloa]

I would like to know how the time comparison works since I have several records in a table but it keeps showing me the same value

[dosubot[bot]]

In Apache Superset, time comparison in table visualizations involves comparing data across different time periods using various calculation types. The columns labeled "Δ" and "%" are likely intended to show the difference and percentage change between the current and previous time periods, respectively.

If these columns are showing zeros, it might be due to identical values in the time periods being compared, resulting in no change. This could happen if the data for the selected time periods is the same, or if the time comparison settings are not configured correctly.

To address this, you can check the following:

1. Time Shift Configuration: Ensure that the time shift is set correctly to compare different periods. You can use options like "1 day ago", "1 week ago", etc., to specify the time shift ^[1].

2. Calculation Type: Verify that the calculation type is set to show differences or percentage changes. The available options include actual values, difference, percentage change, and ratio ^[1].

3. Data Validity: Confirm that the data for the selected time periods is not identical, as this would naturally result in zero differences and percentage changes.

Adjusting these settings should help in displaying meaningful time comparison data in your table visualization.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}

[Yisel-Ulloa]

@dosu
What calculations does "Summary" do within the tables?

[dosubot[bot]]

The 'Summary' feature in Apache Superset's table visualizations aggregates data across all rows for selected metrics. It provides a total or summary of the data, and the row limit does not apply to these aggregations. The summary row is displayed in the footer of the table, showing the aggregated values for each metric ^[1].

In your table, the 'Summary' row calculations for the columns are as follows:

• Main: This column shows the total count of the main values, which is 2 in your case.
• #: This column represents the total absolute differences, which is 7.
• Δ: This column shows the total change in values, which is -5.
• %: This column displays the total percentage change, which is -71.429%.

These calculations are based on the aggregation of the respective values across all rows in the table.

To continue talking to Dosu, mention @dosu.

---

^{Help Dosu learn! Give it feedback: Great Response | Irrelevant Answer | Incorrect Sources | Too Verbose | Hallucination | Other}