Line Chart - Line not Making Sense!

[dinicholls]

Hi,

I have a really basic line chart in my app.

Dimensions are Extract Date, and Company Name.

Expression is: sum([Account Balance])  as 'Line Debt'.

When I apply everything, the graph comes out like the first one in the attachment, when I want it to appear like the second one.

What am I doing wrong?! There are no filters or anything in my chart. The extract dates are exactly the same, and the dat is pulling from a single QVD file.

Any help appreciated!

Di

[awhitfield]

What do you mean by 'When I apply everything' please?

[awhitfield]

Also, could you posted the actual QVW?

[Anonymous]

have you tried to change the order of your dimensions?

[jonathandienst · Accepted solution]

Hi

Try continuous axes for the x axis in the chart.

There may be something odd about your dates - perhaps they have a time component. Use Date(Floor(ExtractDate)) to remove the time component.

HTH

Jonathan

[dinicholls]

Thank You Jonathan!

I always forget there might be a time bit to it!

Di