Birt Reports

Hi, I'm trying to plot chart as shown in attachment.where i have to show on a particular day duration of a task at a particular hour. I grouped x axis(datetime) based on unit day and y axis(datetime) on unit hours. I'm not getting hours plotted properly on y axis. I can see correct hours 14:00,15:00,17:00 shown side. Data plotted on Aug 20 too is not correct. Other dates plotted correct data Can someone tell what i'm doing wrong?

Find more posts tagged with

Comments

BRM

Do you have the x-axis grouping set to days? Seems to me you want to group by hours.

Rachels

yes,x-axis grouping i set to days.Y-axis i set to hours but on y axis i see 2 ,14 and this repeats. right side colored boxes shows series information which shows correctly hours for which data is generated. 14,15,17 hrs. 14 means 2 PM.this is what is getting plotted on y axis followed by 14 and again 2 followed by 14. Can some one suggest?

BRM

I also notice that you have two y-axes here. make sure the data is getting plotted on the correct one. Is it possible for you you post a report design and an idea of what you expect the result to be?

Rachels

I need 2 y axes,one for values and other for time .Please find attachment how my data looks like

So on X axis i need Date Aug 20,2013.Y axis i need values.And on secondary y axis i need time 2:00PM,3:00 PM,5:00 PM

As u can see in my first post screenshot.X axis and Y axis labels are shown correctly.secondary y axis shows 2:00.14:00 and this repeats.

Instead i want 2:00PM,3:00 PM,5:00 PM or 24 hr format 14:00,15:00,17:00. in the snapshot next to secondary axes,legends are shown with correctly these values. I need these values on secondary y axis.

BRM

A two dimensional chart with a primary and secondary y-axes is used to show the values of two different data series, not two different attributes of the same data series. Simultaneously showing two separate attributes of a set categorical values (i.e. x-axis) requires a three dimensional chart but you don't have that here. The x-axis in your original post is a date/time axis so it has dates and times of these events. The primary y-axis has the values of these events. On the secondary y-axis you are trying to indicate the times of these events, but the time of the event is an x-axis dimension. The chart cannot simultaneously plot the height of a bar as 5438 on the primary y-axis and 2:00pm on the secondary y-axis. If you are trying to help the viewer understand what bars correspond to what events you can make use of the legend, or more precise formatting of the x-axis (i.e. to show time of the event as well as the date) or the interactivity features of the chart if you want to go that route. If you have to have the times of the event on the secondary y-axis as you describe then you are going to have to create another dummy data series to plot on the secondary y-axis that will result in its being scaled the way you require. You can have the x-axis values of this series all be something that won't show up on your chart. You can use scaling to to do this. Hope that helps.