1 Reply Latest reply: Jan 4, 2017 12:14 AM by Yasmeen K RSS

    How to restrict zeros in bar chart?

    bhawana adhikari

      Hi all,


      I have a bar chart which displays around 1000000 zeros before actual values are displayed. I just wanted bottom 20 values in bar chart . How can I do this?


      I have DSI as a measure and contains negative and positive values in it.(after summing DSI from each condition , I want to remove zeros from below expression


      if(GetSelectedCount([Month])=0 and GetSelectedCount([Fiscal Year])=0,


      num(sum({<calendar_year_month =  {'$(=Max(calendar_year_month))'}, report_metric_key={'4'}>}DSI),'#,##0')