Gantt Chart

[morphy]

Hi everybody

is it possible to create a Gantt Chart with Report Studio?


If not, is it possible to create a 2-axis chart with Time on x-axis?

How do I get Time if Time is not a column retrieved by the Query?

For example:
my Query retrieves this columns:

CODE  START DATE   END DATE   DATE OF COMPLETION

1          1/3/2009       15/3/2009           7/3/2009
2          16/3/2009      30/3/2009           22/3/2009
...

I would like to have TIME on x-axis and the 3 dates for each code on the y-axis.

The aim of the chart is to see if the work (CODE) has been completed between the start and end date.


MANY THANKS IN ADVANCE!!!

CIAO

MORPHY

[tiga123]

Hi Morphy,

I know you can create a gantt chart by using a crosstab.


- Create your measure in query1 including the dates(start and enddate), put the time in query2 and join them 0.n (between time A and time B). in this case even there is no time, it will be showed on your report. I inserted the time query as an dimension in the datawarehouse. just generate it in excel. 0:00 0:01 0.02.....
- then IF date between starttime and endtime then 1 else 0.
- with conditional formatting IF cell is 1 then color, else no color...

             | 0.00 | 0.30 | 1.00 | .......
----------
1/3/2009 |   1        1
2/3/2009 |
3/3/2009 |
 

one thing you have to mention(problems which I'm suffering) is that if you want a one minute accuracy that the width of your report will be veryyyy big.




 

[morphy]

Many thanks Tiga,

I got you!

No problem for the accuracy. It will not be so deep (Days).

Just give me a further explanation:

What do u mean when you say 'put the time in Query 2'

And what is Time A and B? I have 3 Dates....

Thanks a lot!

Ciao

Morphy

[tiga123]

Because you don't use time, forget the time in query2, use date.

query1                            query2
--------                         --------
startdate         >=                date
enddate           <=
measure
 
Check also your cardinality, startdate has one or more dates
OR
startdate has zero or more dates (because probably you want to see all dates even there are no measures )


             | 01-01-2009 | 02-01-2009 | 03-01-2009 | .......
----------
1/3/2009 |        1                 1
2/3/2009 |                           1                 
3/3/2009 |                                               

[morphy]

Ciao Tiga,

Thank u very much 4 yr help.

I tried and it works perfectly!

May I ask u another suggestion?

How would u set yr crosstab if u would have also a third time data
(Date of Completion) in yr rows of the crosstab (the other two are Start Date and End Date).

I would like that the cell related to the Completion Date will be in a different color.

For example the cells between the Start Date and the End Date will have to be blue and the cell for the Completion date will have to be green (even if the Completion Date is inside or outside the range of the Start and End Dates!).

What will be the condition?

Many thanks for what u r doing.
I appreciate.

Ciao

Morphy

[tiga123]

Is there a possibility  to change your If then else statement?
should look something like:

case
    when date = CompleteDate and Date between starttime and endtime then 2
    when date <> CompleteDate and Date between starttime and endtime then 1
    else 0
end

then it will be showed as:

             | 01-01-2009 | 02-01-2009 | 03-01-2009 | .......
----------
1/3/2009 |        1                 1                 2
2/3/2009 |                           1                 
3/3/2009 |