| help [message #335541] |
Tue, 22 July 2008 08:56  |
aarti81
Messages: 235
Registered: December 2007
Location: USA
|
Senior Member |
|
|
Hi All
I have to create a report where there are four stages on the X aixs:
oncall-unit price
oncall-negotiated rate
project specific
amendments
I have to find the number of firms for each stage for each quarter in a graph.
My question is how do i get the 4 stages on the Xaxis ?
any advice will be of grt help.
thnks
|
|
|
|
| Re: help [message #335637 is a reply to message #335541] |
Wed, 23 July 2008 01:33  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
|
Could you tell us what the data model is you're working with? (table descriptions and preferably some sample data)
|
|
|
|
| Re: help [message #335748 is a reply to message #335637] |
Wed, 23 July 2008 09:13 |
aarti81
Messages: 235
Registered: December 2007
Location: USA
|
Senior Member |
|
|
Thanks for the reply
I have a table in which i have 2 fields: contract_type and contract_comp_method
On the X axis i need to have 4 combinations of the above 2 fields
1)contract_type=on call and contract_comp_method=unit price
2)on call and negotiated rate
3)project specific and other
4)amendments
its like group A,B,C,D
and on the Y XAIS i need to have the number of days and the graph must represent the quarter for each color of the bar from 2006 to 2008.
thnks
|
|
|
|
| Re: help [message #335886 is a reply to message #335748] |
Thu, 24 July 2008 01:42 |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
The information you provided can not be complete, since you only mention 1 table with 2 columns, which can never result into a graph with number of days. It would make matters a bit easier of you would provide the complete details.
However, I think you are looking for a calculated item, something like:
case when column_a = 'x' and column_b like 'abc%' then 'A'
when column_a = 'x' and column_b not like 'abc%' then 'B'
when column_a in ('y','z') then 'C'
else 'D'
end
Enter the conditions as needed in the various when statements.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
