download as pivoted excel in custom pivot plugin

[srijani-smsrc]

I have made a new pivot plugin , with some visualization changes , and registered in mainpreset , new SmsrcEchartsPieChartPlugin().configure({ key: 'smsrc-custom-pivot' }),

but superset 6 give custom download option as pivoted excel or csv which i am not getting in my plugin
how to fix that.
i need to keep both the custom pivot and the normal pivot in my project

@dosubot

[dosubot[bot]]

The "download as pivoted excel/CSV" functionality in Superset is hardcoded for specific viz types—it's not automatically inherited by custom plugins. Your 'smsrc-custom-pivot' doesn't show the option because the UI checks for specific viz_type strings.

To enable pivoted downloads for your custom plugin, you'll need to modify Superset's core code in three places:

1. Frontend - Export Menu (useExploreAdditionalActionsMenu/index.jsx)

Add your viz_type to the VIZ_TYPES_PIVOTABLE array:

const VIZ_TYPES_PIVOTABLE = [
  VizType.PivotTable,
  'smsrc-custom-pivot',  // Add your custom viz_type
];

2. Frontend - Dashboard Export (SliceHeaderControls/index.tsx)

Update the pivot table check to include your viz_type:

const isPivotTable = slice.viz_type === VizType.PivotTable || 
                     slice.viz_type === 'smsrc-custom-pivot';

3. Backend - Post Processor (client_processing.py)

Register your viz_type in the post_processors dictionary:

post_processors = {
    "pivot_table_v2": pivot_table_v2,
    "table": table,
    "smsrc-custom-pivot": pivot_table_v2,  # Reuse existing logic if your data structure matches
}

If your custom pivot uses the same data structure as the default pivot table, you can reuse the pivot_table_v2 post-processor. Otherwise, you'll need to implement a custom transformation function.

Unfortunately, there's no plugin metadata or Behavior property to enable this declaratively—the export functionality is currently tied to hardcoded viz_type checks.

To reply, just mention @dosu.

---

Share context across your team and agents. Try Dosu.

[srijani-smsrc]

does superset 5 give the option for pivoted excel/csv option for pivot table in general?

@dosu

[dosubot[bot]]

Your organization has reached the limit of 200 credits per month. Your usage will reset on 2026-10-01. If you'd like to use Dosu before then, upgrade to a pro account.

To reply, just mention @dosu.

---

Share context across your team and agents. Try Dosu.

[SrijaniDasgupta]

does superset 5 give the option for pivoted excel/csv option for pivot table in general?

@dosu