display empty cells in Table widget for missing data instead of NULL or N\A

Comments

4 comments

  • Avatar
    An Y

    +1 to this request.

    Ryszard - Mind sharing the JS  that you are using to change the display  for Table?

    An

     

    0
    Comment actions Permalink
  • Avatar
    Ryszard Czerminski

    This is what I got from support which sort-off works (see caveats below):

    widget.on('ready', function(){
    $('td[class*=p-value] div, td[class*=p-dim-member] span', element).map(function(i, cell) {
    if(cell.innerHTML == "N\\A" ) cell.innerHTML='';
    })
    })

     

    It works fine for a single TABLE widget, note however that you might need to remove browser cache to see a difference.

    It would be much better if this is included as some kind of global display option. Upvote this post so hopefully, this request move up in the pile :)

    0
    Comment actions Permalink
  • Avatar
    JJ Chritton

    Unfortunately the script above doesn't work for me on 7.1.3. I've tried a few other amended scripts but they have not worked either.

    I would agree this should be a default design option rather than a script: most people would never want to see 'N\A' in a table or a pivot table.

    0
    Comment actions Permalink
  • Avatar
    Anjali Yadav (Edited )

    Isn't 'Not Applicable' abbreviated as  N/A  , with a right slash , instead of the left slash that Sisense  shows as a default? Wondering how to switch it up?

    1
    Comment actions Permalink

Please sign in to leave a comment.