Home » Fusion Middleware & Colab Suite » Business Intelligence » Specifying the colours in Pie Chart (BIP - Oracle 10g )
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


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


Current Time: Thu Mar 28 04:00:07 CDT 2024