COGNOiSe.com - The IBM Cognos Community

I was trying to plot a line chart and in which it should take dates with an incremental of 2 hours on the X axis. I had three columns(X, Y, Z) in my list from which the chart should take the min of X date to max of Y date. Please help me how to derive the calculated column for this such that I can plot that as X-axis in my line chart.

I am attaching a copy of the report which was developed in EXCEL (I should use the min(OTS) and max(ETR))

Thanks in advance.
Please help me with a solution


                            Tue     14th                                                                       Wed 15th               
OTS   ETR   RTS      0600   0800   1000   1200   1400   1600   1800   2000   2200   0600   0800   1000 1200 1400 1600 1800 2000 2200...
                                                         
0640/14   1300/14   1130/14                                                       
                                                         
0640/14   1200/14   1410/14                                                        
                                                         
0535/14   1800/14                                                             
                                                         
2101/13   2300/15                                                                     
                                                         
1750/13   1100/14   1115/14                                                       
                                                         
0730/13   2300/15                                                                     
                                                         
0400/14   1500/14                                                            
                                                         
0100/14   1000/14   1030/14                                                      
                                                         
0355/12   0500/15                                                      
                                                         
0610/14   0900/14   0900/14                                                      
                                                         
1200/14   D0500/15