Pivot view needs to support excel-styled multiple rows&cols, conditional formatting to be actuallly useful

[retopara]

Is your feature request related to a problem? Please describe. Cannot insert a useful pivot table of data in the dashboard. Lots of use cases require reviewing data side by side with the plots, so pivot table is actually a super important feature.

Describe the solution you'd like Pivot View needs the following features to be actually useful. 1、Adding multiple rows and columns and display them in sub-groups, see the FIG below

2、Adding conditional formatting to data grids, better to start from color scale, see the FIG below

Describe alternatives you've considered nothing except for using offline excel files.

[TorreyBetts]

Hello!

The pivot grid does support excel-style multiple rows and columns, see the image below.

Conditional formatting does have some support. You can view some documentation about it at this location. We're still improving documentation so it's possible you didn't find this information within our product, let us know if you have more questions or feature requests based off this new information.