Set analysis in Pivot with no result Null Value

RC_121985 — Wed, 05 May 2021 14:01:27 GMT

Namaste 🙏,

I am trying to color the pivot back ground based on the result. All working good, but some values resulting Null values and as all know we can't have color to null and need to have 0 or other values to achieve it.

My expression in Measure : to give the count of Open status by different dimension in Pivot

Count({<DATE={"<=$(=(DATESELECT))"},STATUS={'OPEN'}>}COUNTKEY)

(*DATESELECT is Variable Key)

My Color expression in Background Color :

If(GROUP='GROUP1','#ffe53c',
If(GROUP='GROUP2','#FFA726',
If(GROUP='GROUP3','#EF8383',
If(GROUP='GROUP4','#BE2D2D',
If(GROUP='GROUP5','#7E0E0E',White())))))

My expression in Measure resulting in null values for some dimensions for which my expression in Color not able to color it.

So, how do i change my expression in measure to result the null to Zero.

Thanks,

Re: Set analysis in Pivot with no result Null Value

Digvijay_Singh — Tue, 11 May 2021 02:34:33 GMT

Not sure if I understand the problem fully but you may try coalesce function if available in your release -

something like - Coalesce(Count({<DATE={"<=$(=(DATESELECT))"},STATUS={'OPEN'}>}COUNTKEY),0)

Or ALT(Count({<DATE={"<=$(=(DATESELECT))"},STATUS={'OPEN'}>}COUNTKEY),0)

topic Set analysis in Pivot with no result Null Value in App Development

Set analysis in Pivot with no result Null Value

Re: Set analysis in Pivot with no result Null Value