Databricks Dashboards - display totals in Tables

[Diegol1337]

I was wondering if anyone has been able to display totals in a Table/Pivot visualization? Similar to what is possible in other BI tools?

If I have a table with a bunch of rows and one of the columns is Total Cost, I want to be able to show a Total at the end of the table which sums the total cost of the column. Would also like for the Total to be flexible and always displayed.

If possible would like to avoid calculating the Total in a SQL query, any ideas

[bianca_unifeye]

At the moment, Databricks visualizations do not natively support dynamic total rows or grand totals like Excel or Power BI do.
You can show aggregations (SUM, AVG, etc.) in your query, but the visualization layer itself won’t automatically display a “Total” row at the bottom.

If you build dashboards through notebooks or SQL queries, you can use a DataFrame summary and render via display(). Simpler way, it is still sql, use UNION ALL. You can always built a custom visual.

Databricks has this feature on the roadmap for Lakeview Table visualizations, expected to support total and subtotal rows similar to pivot tables soon, but I don't know the release date!