Skip to main content

Hi,

 

I created an Actual/Fcst measure under Actual table and am trying to write an calculated field like this:

 

For 2017 Actual

If Actual Volume is not available (e.g. 4/6/2017....12/31/2017, use 2017 FCST.

If Actual Volume is available, use 2017 Actual.

 

Could anyone teach me how to write this calculated field? I am currently using tableau v9.2

 

Two datasets:

1. Actual Table: daily volume starting from 01/01/2015-04/04/2017(till now).

2. Forecast Table: daily forecast starting from 01/01/2017-12/31/2017.

 

Thanks!

13 answers
  1. Apr 6, 2017, 5:23 PM

    Sissi,

     

    Yes, because you are blending data, G.Total is tricky.

    We need to control the secondary data source data itself, the only way I can achieve this is thru parameter.

     

    Sissi, Yes, because you are blending data, G.Total is tricky.We need to control the secondary data source data itself, the only way I can achieve this is thru parameter.

     

    pastedImage_1.png

     

    pastedImage_2.png

     

    pastedImage_3.png

     

    pastedImage_0.png

     

    pastedImage_1.png

     

    Thanks,

    Shin

0/9000