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?

  • 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.

  • 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.

  • Avatar
    Inbal

    Hi Joseph,

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

    Enjoy!

  • 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?

  • Avatar
    Jonathan Pires

    Hi Dimitar,

     

    What version of Sisense are you currently using?

  • Avatar
    Siva

    can we have similar solution for pie chart.?

  • Avatar
    Dot Q

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

Please sign in to leave a comment.