Removing the standard COUNT measure

Question

Question

Lawrence Grace · Sep 12, 2019

#InterSystems IRIS BI (DeepSee)

Is there any way to remove the Count measure from a pivot table or more importantly, a DeepSee widget.

Even if I do not add it as a measure in the Analyzer, the column "All" shows up.

Anyone have an idea on how to hide or remove it in a Dashboard Widget?

Thanks,

LG

Discussion (3)1

Log in or sign up to continue

Evgeny Shvarov · Sep 13, 2019

The answer is:

To remove the Count measure put any other measure of the cube into the Measures section of the Pivot.

0 0

score 0 · Answer 1 · 2019-09-13T13:56:54-04:00

Hi Lawrence!

But if you remove Count what number do you want to calculate? Do you have any other measure?

The nature of pivots is that you need at least one measure in a pivot. If you don't supply any DeepSee takes Count by default - the amount of Facts in your Fact table.

score 0 · Answer 2 · 2019-09-13T14:56:59-04:00

Lawrence Grace · Sep 13, 2019

Thank you, Evgeny.

As for a replacement, I haven't given that any thought.

0 0