Unable to see blank records in pivot

Aspiring_Developer — Thu, 30 Sep 2021 15:30:10 GMT

Hi All,

I have below table :-

As you can see I have two records for test uat2 having different comments , one is 'testtt' which is added by user and other one is 'No input by user' which is added by me to replace blank value.

When I take the same thing in pivot table, i am unable to see the second record of test uat:-

I don't know why it is working in one visual and not in other visualization of pivot. I have not suppressed null value for any dimension. I have checked the box 'Include null values ' for all columns.

The expression for comment is here below :-

only({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} if( len(trim(COMMENT_TEXT))=0, 'No Input bu user', COMMENT_TEXT))

And for Traffic Light:-

=pick(match(only(activity_color),'error','none','success','warning'), RGB(203,67,53), RGB(247,249,249), RGB(39,174,96), RGB(243,156,18))

Can anyone please help ?

Thank You

Re: Unable to see blank records in pivot

stevejoyce — Thu, 30 Sep 2021 16:51:48 GMT

Doesn't this mean you have 2 comments for "test uat2"

Only function will return a value if there is only 1 value.

If you want to show all comments for a given cell, switch to concat()

concat({<INPUT_DATE = {">=$(=Date(MonthStart(Max([INPUT_DATE]))))<=$(=Date(Max([INPUT_DATE])))"}>} if( len(trim(COMMENT_TEXT))=0, 'No Input bu user', COMMENT_TEXT), ', ')

topic Re: Unable to see blank records in pivot in App Development

Unable to see blank records in pivot

Re: Unable to see blank records in pivot