Time Dimension Detail: Use the Pivot Table component

[ericpgreen2]

Relevant PRDs

https://www.notion.so/rilldata/Bring-Pivot-table-component-to-other-surfaces-118eaa353840495baa68879d7152428a
https://www.notion.so/rilldata/Bring-time-comparison-columns-to-TDD-118eaa353840495baa68879d7152428a
https://www.notion.so/rilldata/Time-Dimension-Detail-Design-Mocks-and-Specification-3072abfbc64f4c6288412ff06949d60f

TODOs

P0

• Pivot Table: Add column virtualization #6159 (@lovincyrus) (Pivot table column virtualization #6141)
• Pivot Table: Add search for use in TDD #6158 (@djbarnwal)
• Pivot Table: Add ability to select values in TDD #6160 (@lovincyrus)
• Pivot Table: Integrate with TDD's header controls  #6161 (@lovincyrus)
• Pivot Table: for TDD, for the compared dimension, do not remove the filtered dimension values from the table #6162 (@djbarnwal)
• Pivot Table: Add infinite column scroll to support high cardinality of time dimension #6163 (@djbarnwal)
• Pivot Table: Add e2e test for row- and column- infinite scroll #6164 (@djbarnwal)

P1

• Add sparkline column
• Add pinning column and refactor to use null based indexing
• On scrub update totals row
• Add bidirectional interaction with charts
• Style according to mocks

P2

• Merge column headers when only 1 measure
• Optimize pivot data store for dates
• Memoize the table when custom config if provided
• Add tooltips for delta column headers
• Remove existing usage of time dimension store
• Refactor multiple-dimension-queries to work just for charts
• Do not bold values in rows when there is only a single column

Completed

• Create pivot config for TDD table
• Create new column definitions for TDD