putting your expression inside the if(errorcode, ) part should tell it to give an answer only if there's a value in the errorcode field/column.
Other option is to suppress nulls somewhere in there, but I like the if statement because it keeps it clear what you are doing all in one place.
Update: try removing the time dimension and using the expression: if(errorcode, time) instead. If it's a bar chart or pie chart, using errorcode as the dimension and if(errorcode, count(something)) as the expression should get you counts of somethings broken out by errorcode #.
thanks Steve ,
the if condition works , if the error is a number, we have the error as alpha numberic it can be us C1 , C2 , H1 and so...
my table actually look link the bleow
order_numj Status Error Time 1234 New 2 12-Jul-13 1123 Rec A1 12-Jul-13 1232 SND 12-Jul-13 1234 REC C2 12-Jul-13
When i use the if condition as if (error , count(order_num )) my bar char returns the vales only for the numbers and does not display all the alpha numeric code .
Are you trying to hide rows that don't have a value in the error field. If so on the dimensions tab highlight the error dimension and check the box "Suppress when Value is null". If you are using a table box this option is on the presentation tab. Highlight the error field and check the "Omit Values where field is null" box.
What kind of object is it? A table box or a chart. If it's a chart what are your dimensions and expressions?
the table is not having a null value, it has blanks. need to display the count of the orders with particular error code in the bar chart.
I dont need the count of orders with the blanks but with the below expression am gettting a bar for the count of balnks in the chart.
Am using a chart object and using a bar chart.
my exression is count(order_num)
dimensions is error