topic Re: How to get distinct count even after having multiple dimensions in App Development

How to get distinct count even after having multiple dimensions

loganathan — Wed, 31 May 2023 14:03:13 GMT

Hi All,

i have data like,

if i do 'Distinct count of alerts' in KPI i will get 4.

like same if i do 'Distinct count of alerts' in table where my dimensions are day and month i will get 5. which is valid.

but in table too i need it to be '4' as i dont want to count 'A1' again means my result table must be like below. Any idea how to achieve this.

Chanty4u — Wed, 31 May 2023 14:39:38 GMT

Try this

Count({<alerts = {"=Count(distinct {<day, month> alerts) > 0"}>} alerts)

loganathan — Wed, 31 May 2023 20:21:16 GMT

Hi,

Thanks for your quick response. But this expression doesn't work. TIA

BrunPierre — Wed, 31 May 2023 22:28:46 GMT

Hi, Try this.

Count(DISTINCT If(Aggr (Count(DISTINCT alerts), month, day) = 1, alerts, Null()))

loganathan — Thu, 01 Jun 2023 04:42:57 GMT

Hi Brun Pierre,

Thanks for your help. but tried with this condition still it doesnt work. Please advise.

Thanks.,

tresB — Thu, 01 Jun 2023 05:36:21 GMT

Note: Disable zero/null suppression

BrunPierre — Thu, 01 Jun 2023 07:11:20 GMT

Count(Aggr(Only(alerts), alerts))