OraFAQ Forum: Business Intelligence » Specifying the colours in Pie Chart

Home » Fusion Middleware & Colab Suite » Business Intelligence » Specifying the colours in Pie Chart (BIP - Oracle 10g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Specifying the colours in Pie Chart [message #537460]

Wed, 28 December 2011 09:26

baskaranprasad
Messages: 13
Registered: August 2006
Location: Bangalore

Junior Member

Dear Expert Group,

I am facing an issue while designing the PIE Charts for my Simple query.

Quote:

SELECT DECODE(UPLOAD_STATUS,
'Y',
'Success',
'P',
'Success',
'S',
'Success',
'E',
'Error') cop_status,
COUNT(*) cop_count_1
FROM GETU_POOL_I
GROUP BY (UPLOAD_STATUS)

I want to fix the color for Success in "Green" and "Errors" in "Red". How do I do that? Currently if there are no failures then my pie chart is showing 100% "success" in RED color which is not logically correct. Expecting your Soonest response.

Thanks & Regards,
Baskaranprasad

Report message to a moderator

Previous Topic:	Error in Answer with columns from 2 Dim tables
Next Topic:	send email by XML

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 04 17:43:00 CST 2025