Subscription formatting of Pivottables

Get Help
1

I have setup a dashboard containing a Pivot table with 6 columns. It looks perfect in a browser, but the issue is when I have created a subscription. I receive the mail, but the pivottable is changed to a "long" format instead of "wide" meaning it looks completely different. In browser I have "Customer" in rows, "Week" in columns and "Amount" as a value. In the subscription mail "Week" is moved to be a row value in order to make the pivot table fit the format of the subscription mail.

Can this be changed so the pivot table looks the same in the mail as on web? I know I of course can remove some columns, but I have not chosen that many after all.

2

I think there is a bug report for this already, it also happens in Slack subscriptions. I don't think it's being fixed until they change the pivot table viz library - which has been open for 2 years now :smiley:

Could be related to this... Pivot tables should appear as pivot tables (not tables) in subscriptions · Issue #43638 · metabase/metabase · GitHub

3

the pivot table is a frontend representation, while all other visualizations are actually something we do on the backend. Till that's not fixed, we can't "show" pivot tables on the subscriptions