for my oppinion both charts are correct. For ex. in the left chart the dimensions are DATE and user_type. In the underlying tables are three dates and all valid data belonging to these are shown (summed up). Valid data in this case is a value in all three fields: DATE and user_type and current_cost (via queriesperday.K1 and K2). To verify (test) this build a tablebox (not a chart) containing this three fields. There you can find all nullvalues as dashes.
If you want to see "all" data in a chart, even null-values, there are some options to be (un-)checked:
tab Dimensions --> "Supress When Value Is Null" (for every dim !)
tab Dimensions --> "Show All Values" (for every dim !)
tab expressions --> "Suppress Zero-Vals"
tab expressions --> "Suppress Missing"
But I guess You won't be happy when you see "all data".
I think its just that your links are scattered,'Fresh fix-ups'almost always come from an organised prob,
Pull in the tables the same way you did,just Make sure the MAIN Table has a consistant ammount of fields able -
-to link all needed tables,ofcourse Watching for synthc keys but all else looks right,
I would(if stuck in your position) also find all null values 1st,from there...no idea as iv also just recently started.
hope you get it right.