1 of 1 people found this helpful
Building worksheets off of blended datasources is impacted by which datasource's fields you bring onto your viz first, as well as which fields your blending on. If you want to make sure the goal shows up then drag a field from that datasource on first. You may need to use an ifnull or zn calculation to return a zero value instead of a null for your targets.
I do not believe this is an issue with your datasource types.
Thanks for your answer! I did make sure that targets are the primary data source for this viz. However I haven't used and ifnull or zn calculation.
Following your advice, I've tried using IFNULL(Secondary_source.progress,0) and brought it to the viz, but I still only get progress for existing projects, not the ones that haven't been started yet...
Sorry if I wasn't clear. I know that targets your primary data source on your blend. However, on the actual worksheet where you're building this view, you need to drag a field from your Goal datasource onto it first. That needs to be the main datasource on your view (this has nothing to do with your blend set up). That way, the goals should show up even if targets are null.
If you were able to mock up some fake data for this and attach a workbook, it'd be much easier to troubleshoot, but hope this helps.
goals: primary and targets: secondary. when u blend them , it will behave like goals left join target
Replying to my own question:
Thanks for your help everyone! I've found what was happening: I had some filters on the secondary data source. This means that it forces the view to display only relevant data in the secondary data source.
Therefore it cannot display null data. To overcome this, I've added a filter straight into the data source and not in the view.