Forum Discussion
Data Not Showing
Hi Anonymous,
To what I can understand you make the connection between your two table by the column date and not by a dimension table of dates correct?
When connecting tables directly trough fields that don't have a specific value on it (in this case your Actual service don't have data for November and December) if you use that column (without data) to fullfil your visuals although the totals are correct the individual values will be change due to context.
You should do a Date table and related both tables by that dimension table and use it on your visual, this will fullfill the blank spaces of dates and return blank for the actuals and the for the goal
Regards.
MFelix
Hi Anonymous,
To what I can understand you make the connection between your two table by the column date and not by a dimension table of dates correct?
When connecting tables directly trough fields that don't have a specific value on it (in this case your Actual service don't have data for November and December) if you use that column (without data) to fullfil your visuals although the totals are correct the individual values will be change due to context.
You should do a Date table and related both tables by that dimension table and use it on your visual, this will fullfill the blank spaces of dates and return blank for the actuals and the for the goal
Regards.
MFelix