Why is my line flat, on bar and line graph?

[KathyO]

Help please!  Why can I get this data (relating to producted delivered (bars) and hours worked (lines) sucessfully on separate graphs, but when I try to put them onto one visualisation together, the line goes flat?

Both data tables are linked to a rolling calendar table...

I just can't figure it out!

Thanks

[hansontm]

Yes it likely has to do with the relationship between data tables and calendar table or 'Dispatch Date Calc' which i see in the bar charts but not line chart. Where does that field come from?

[danextian · Accepted solution]

I am suspecting the dates used are from where the columns are from instead of from the connecting date table.

[KathyO]

Except now I'm struggling to get the chart in date order, by week... any advice?

I've tried adding a couple of different columns to my rolling calendar then sorting the "Start of Week" field by that column, but I obviously haven't hit the right code...

[danextian]

Except now I'm struggling to get the chart in date order, by week... any advice? -  The dates look in order to me.

[KathyO]

So simple, that fixed it, thank you so much!