Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
Hope you had a blessed close of year.
I have a chart which I am trying to use Set Analysis in the Select in Field action within the Text Object and I cannot seem to get it to work right.
This is my expression:
Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'},[#of Days Post VPP]=-{' '}>}Gateways)
And truly all I need is to display everything that is not blank within the #of Days Post VPP field. I have both negative and positive values in the field and I need to capture each one and ONLY exclude blanks.
Any help provided will be truly appreciated.
Thanks.
Zoe M.
Thanks for the responses guys, I tried and found that the easiest way in this case was to identify the field (column) items before they come into the dashboard (using alteryx to wrangle data).
Thanks!
This expression wont work inside the select in field action. Try Select in field action seperately for fields ( [Date Type] ,Reference_Only ).
Regarding [#of Days Post VPP], kindly refer the below link.
Thanks for the responses guys, I tried and found that the easiest way in this case was to identify the field (column) items before they come into the dashboard (using alteryx to wrangle data).
Thanks!