cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Panda2018 Member
Member

Data Not Showing

I Have Two Data Tables. One table has Staff's Actual Service Provided Numbers & The Other has their Service Goal numbers (For 3 month. I have Connected them through Date & Staff ID Numbers. Even if they haven't done any service, it should populate their Goal numbers for all the months. If you see the Picture below you will see the Highlighted staff line, the staff has done service for Oct 5.50Hour so his Goal is showing 24. But because he has't done any service for November & December,  his Goals for these months are empty. It should show the goal 24 for Nov & Dec. But It's showing the Total 72.0 (24 for 3 months)

Goal Table.PNG

 

 

 

Please advice.

Thanks,

panda2018

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Data Not Showing

Hi @Panda2018,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




1 REPLY 1
Super User
Super User

Re: Data Not Showing

Hi @Panda2018,

 

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



Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!