Hi community! Me again! there is any chance to get on a SQL, a last row that provides the Grand Total for all the numeric columns?.
I know the Pivot table let do this, but we need it on the SQL results. Thanks in advance!
Hi community! Me again! there is any chance to get on a SQL, a last row that provides the Grand Total for all the numeric columns?.
I know the Pivot table let do this, but we need it on the SQL results. Thanks in advance!
Hello ! looked at the side of the count() function in SQL!
Hi Anthony! Thanks, but the issue is that I have already different counts and/or sums from different tables at the same SQL and does not work...
Hi @albertogc
You can use a SQL question as the base via Saved Questions, so you can use Pivot Table: https://www.metabase.com/docs/latest/questions/sharing/visualizing-results#pivot-table
If you want to do it all in SQL, then you'll have to adjust the query, so it adds a grand total. How to do that depends on your database type. Example https://stackoverflow.com/questions/17934318/add-a-summary-row-with-totals