Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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), ', ')