Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
=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 #.
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
Try
If(Len(Trim(Error)) > 0, Count(Order_Num)
yahooooo... that works thanks
Dang, and I’m so close to 1000 points!