feat: support multiple time columns with time grain in Pivot Table v2

[zhaoyongjie]

SUMMARY

If the FF Generic Axis is enabled, the Pivot Table v2 will support multiple time columns with time grain. The TIME GRAIN control also moves out from the time section.

There is a limitation in the current design that the Adhoc Column wasn't able to apply the Time Grain, I will open separated PR to support the dynamic detector for the column type.

BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF

After

The time grain is applied on Order Date and Ship Date

The time grain is applied on Order Date and Ship Date except Category

TESTING INSTRUCTIONS

ADDITIONAL INFORMATION

• Has associated issue:
• Required feature flags:
• Changes UI
• Includes DB Migration (follow approval process in SIP-59)
  • Migration is atomic, supports rollback & is backwards-compatible
  • Confirm DB migration upgrade and downgrade tested
  • Runtime estimates and downtime expectations provided
• Introduces new feature or API
• Removes existing feature or API

[codecov]

Codecov Report

Merging #21537 (8f64fe5) into master (4d12e37) will increase coverage by 0.00%.
The diff coverage is 15.00%.

@@           Coverage Diff           @@
##           master   #21537   +/-   ##
=======================================
  Coverage   66.68%   66.68%           
=======================================
  Files        1793     1793           
  Lines       68538    68557   +19     
  Branches     7282     7289    +7     
=======================================
+ Hits        45702    45718   +16     
+ Misses      20974    20966    -8     
- Partials     1862     1873   +11     

Flag	Coverage Δ
javascript	52.88% <15.00%> (+0.01%)	⬆️

Flags with carried forward coverage won't be shown. Click here to find out more.

Impacted Files	Coverage Δ
...ugin-chart-pivot-table/src/plugin/controlPanel.tsx	4.16% <0.00%> (-2.98%)	⬇️
...et-ui-chart-controls/src/shared-controls/index.tsx	57.14% <25.00%> (-2.48%)	⬇️
.../plugin-chart-pivot-table/src/plugin/buildQuery.ts	42.85% <33.33%> (-12.70%)	⬇️
...ontend/src/views/CRUD/data/dataset/DatasetList.tsx	57.73% <0.00%> (ø)
...tend/src/views/CRUD/data/database/DatabaseList.tsx	66.00% <0.00%> (ø)
...d/src/SqlLab/components/SaveDatasetModal/index.tsx	52.87% <0.00%> (ø)
...board/components/nativeFilters/FilterBar/index.tsx	66.18% <0.00%> (+5.75%)	⬆️
...rd/components/nativeFilters/FilterBar/keyValue.tsx	40.74% <0.00%> (+22.22%)	⬆️

📣 We’re building smart automated test selection to slash your CI/CD build times. Learn more

[zhaoyongjie]

/testenv up FEATURE_GENERIC_CHART_AXES=true

[github-actions]

@zhaoyongjie Ephemeral environment spinning up at http://52.34.7.237:8080. Credentials are admin/admin. Please allow several minutes for bootstrapping and startup.

[kgabryje]

LGTM!

[github-actions]

Ephemeral environment shutdown and build artifacts deleted.