Best Of

Re: Is it possible to show the parcel percentage instead of parcel quantity on DOMO map?

Yes.

Create a new beastmode: SUM(revenue) /SUM(SUM(revenue) FIXED ())
Use that beastmode as your Province/fsa value
Change the Province/fsa Value to a percentage as shown below:

ColemenWilson

1

Re: Replicate Spreadsheet P&L in Domo

If you add a row number column in your ETL you can use it to place a blank row between two other rows. For example, if I want a blank between Revenue and Wages I could assign a row number between them

And then I can hide column 1 in the chart properties:

This would create an empty row:

You can also play around with column widths in the properties but I don't believe you can selectively make certain columns wider or narrower

ggenovese

2

Re: Add a calculated row in a Table?

So, the question is: how to have sub-totals display in-line with their category and still preserve the ability to have a total row.

Short answer, no you can't do that.

Long answer, you could fake it using an ETL: pre-calculate the sub-totals and totals and append the rows:

Then turn off the subtotals and totals in your card and it will give the desired appearance.

I would not recommend this approach, as it would not be dynamic with filters the way subtotals/totals normally are, but if you just need a static card in this exact format, it would technically work.