13 Replies Latest reply: Jul 8, 2011 5:42 AM by Miguel Angel Baeyens de Arce RSS

    allowing 0 to show on bar chart but not null values

      hi guys, i have a chart to show the bottom 10 usage rate of a device, thus there would be devices that have 0% usage rate...

       

      expression is simply usageTime/totalTime. i also placed the expression in the Sort tab so as to show only the bottom 10...

       

      under Presentation tab, i unchecked Suppress Zero-Values so as to show 0% bar(s) on the charts...

       

      however, null/invalid also show on up the chart (they do not even have a 0% bar)...

       

      now, some background info about my tables. i have 3 tables with the device information, usage rate etc...

       

      usually a device will have records in all 3 tables. however, there are a few devices which have records in only 1 table, resulting in their names appearing on the chart without a bar even when they do not have a usage rate % to show...

       

      Suppress When Value Is Null is already checked under Dimension...

       

      what else can i do?

       

      thanks in advance!