I have a table which is joined to another table on the basis of 2 fields. The problem is that one of the tables has only 3 days worth of data and the other table has data from May onwards. However, i am only able to see data from 3 days due to the join.
I have attached my app with this discussion and also shown the graphs and tables you might need to see.
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".