Removing a blank entries in a table used in charts

[Anonymous]

Hi ,

Is there a way to remove a blank entries in a table while creating a chart.

I have a table which i use to create a chart.as  below

order number     status      errorcode     time

1234                  new                         13-JUL-2013

2313                    rec             2          13-JUL-2013

2122                  red                             13-JUL-2013      

I need to create a chart showing only the orders in the error , the problem is that am not able ot filter out the rows that is blank.  I get a bar for the blank entry in the table.

[swuehl]

I am not really sure what your chart needs to show, but you can probably make it work using a set expression like

=count({<errorcode = {">0"}>} time)

[stevelord]

=if(errorcode, sum(whatever))

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

[Anonymous]

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 .

[jpapador]

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?

[Anonymous]

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

[jpapador · Accepted solution]

Try

If(Len(Trim(Error)) > 0, Count(Order_Num)

[Anonymous]

yahooooo... that works thanks

[stevelord]

Dang, and I’m so close to 1000 points!