Removing 0 and N/A value lables from Column or Bar chart

Comments

8 comments

  • Avatar
    Joseph Peters

    I've tried modifying this code to hide 'N/A' results but haven't been able to.  Tried this.y==null, this.y==undefined and also tried switching the order and doing ((this.y>0) ? (this.y) : "").  Any ideas how to do this?

    0
    Comment actions Permalink
  • Avatar
    Joseph Peters

    Never mind, just realized the code in the posted solution contains an extra parenthesis at the end which is why the code wasn't working.  Removed the parentheses and ((this.y>0) ? (this.y) : "") worked.

    0
    Comment actions Permalink
  • Avatar
    Joseph Peters

    Is there a way to change the code so that it doesn't remove the currency formatting?  I'm doing this for a column chart with $ values but the currency formatting is being cleared by the custom javascript.

    0
    Comment actions Permalink
  • Avatar
    Inbal

    Hi Joseph,

    I just updates the forum post in order to solve the currency issue and also prevent N/A's.

    Enjoy!

    0
    Comment actions Permalink
  • Avatar
    Dimitar Shutev

    Hi,

    Is this script still working? I have tried it on a dashboard and doesn't seem to be doing anything. I have used a stacked bar chart but the N/A remains. Any ideas?

    0
    Comment actions Permalink
  • Avatar
    Jonathan Pires

    Hi Dimitar,

     

    What version of Sisense are you currently using?

    0
    Comment actions Permalink
  • Avatar
    Siva

    can we have similar solution for pie chart.?

    0
    Comment actions Permalink
  • Avatar
    Dot Q

    Agree with Dimitar. I copied this into my widget and it doesn't do anything. I am on version 7.3

    0
    Comment actions Permalink

Please sign in to leave a comment.