Show Totals for a Dimension on a Straight Table

[pedrohenriqueperna]

Hi,

I have a straight table that holds some dimensions that I'm trying to display a count in the totals row.

There are plenty rows, and I need to count the total displayed in the table. The problem is dimensions don't have a total config/option, only measures. If I use a measure and remove the dimension, my table breaks as there are no dimensions to wrap the data.

I've tried using Dimensionality(), but it doesn't work, although it displays the dimensions normally through the rows, except the total:

=If(IsNull(dataEntrega),
If(Dimensionality() = 0, Aggr(Count(id_conhecimento), id_conhecimento), id_conhecimento
)
)

I've searched a bit and found out it could work on pivot tables, but I need to use a straight table.

Is there a workaround?

Thanks in advance.

[Oleg_Troyansky]

As a workaround, even though not ideal, you could add the counts to the dimensions' labels, since adding them to the total line for dimensions doesn't seem to be possible. 

Cheers,

Oleg Troyansky

[pedrohenriqueperna · Accepted solution]

Hi, Oleg

Indeed that's a workaround, but unfortunately it won't fit my needs.

Thanks for the reply anyway.

In case anyone is interested, I've managed to add it by using a CSS helper that I use to edit the css of my dashboards objects. The html structure is the same for dimensions, so I added it using :before. It's far from the ideal, but I can add dynamic values by using variables. It goes something like this:

.sc-dEAvcG div:nth-child(1) div:nth-child(1) div:nth-child(1) div:nth-child(2) div:nth-child(1) div:nth-child(5) span:nth-child(1)::before {
content: "0"; /you can expand a variable holding the value you wish to display
}

You could also add more css rules to match the other total values style.

[vkramBI4Qlik]

Dimensionality works better on Pivot table. Did you try to convert the table to Pivot table with fully expanded and use the dimensionality ?

Thanks.