Skip to main content

Hello,

 

I am still new to Tableau.

 

I am trying to get the corresponding [MTD] value from a blended source "Working days" within my main source "KIA_SALESCUBE"

 

Beginner stuck with getting value from a blended source

 

Because I am using Month filters it is getting the corresponding month value but I need the corresponding day value in my Current working day.

 

pastedImage_1.png

 

How do I get around this?

 

The Working days data looks like this,

 

pastedImage_3.png

 

Any help is appreciated.

 

Thank you

9 respostas
  1. 27 de nov. de 2019, 06:56

    Hello Jason,

     

    In your case, it'll be better to use join instead of data blending.

     

    A sample workbook with two examples is attached.

     

    example 1, mtd is calculated based on the latest data in sales data

    example 2, mtd is calculated based on today

     

    Regards

    Lei

0/9000