6 Replies Latest reply on Dec 3, 2018 3:47 AM by Ombir Rathee

Find count in blended source

Alexander Mik Dec 3, 2018 1:54 AM

Hi,

I have 2 graphs; one where it show revenu over years and one graph where it shows revenu based on a detailed number. This number is only relevant when 1 product is selected. So it should show 1 graph when nothing is selected and the other when a selection in products is made. This worked, but now I have a blended source where my product master list comes from and because of the blend my previous formula isn't working any more. I have no other option then to use the blend unfortunately.

this was my previous formula:

TOTAL( COUNTD( [Book Serie] ) ) = SUM( { FIXED : COUNTD( [Book Serie] )})

THEN

null

ELSE

sum([Rev Books BL])

END

That Book Serie field is now in the blended source and the revenue field is in the primary source.

Hope you guys can help me!

Best regards,

Paul

1. Re: Find count in blended source

Naveen B Dec 3, 2018 2:46 AM (in response to Alexander Mik)

Hi Alexander,

Please find the below link

Vizible Difference: Getting around Count Distinct in a secondary data source

It will be help you create countd on blended data source. Hope this helps

Plz mark this answer as correct or helpful to close the thread

BR,
NB
Like Show 0 Likes(0)

Actions
2. Re: Find count in blended source

Norbert Maijoor Dec 3, 2018 2:48 AM (in response to Alexander Mik)

Hi Alexander,

Could you share your workbook in -tbwx format so the community gets an idea our the data is structered?

Regards,
Norbert
Like Show 0 Likes(0)

Actions
3. Re: Find count in blended source

Alexander Mik Dec 3, 2018 2:59 AM (in response to Naveen B)

I am keep getting the error that the data can't be blended with the other source, even though the calculation is valid..
Like Show 0 Likes(0)

Actions
4. Re: Find count in blended source

Alexander Mik Dec 3, 2018 2:59 AM (in response to Norbert Maijoor)

Hi,

Since this is live customer data I can't share unfortunately

Regards, Alex
Like Show 0 Likes(0)

Actions
5. Re: Find count in blended source

Ivan Ivanov Dec 3, 2018 3:21 AM (in response to Alexander Mik)

Hi, Alexander,
You can create a tableau packaged workbook with dummy data (manually type in some data in excel) and upload the .twbx here.
Like Show 0 Likes(0)

Actions
6. Re: Find count in blended source

Ombir Rathee Dec 3, 2018 3:47 AM (in response to Alexander Mik)

Please create an sample extract and share the twbx file with both sources so that it will be easier to help. If that is not possible then replicate your situation with the help of another dataset and share the file.

CountD doesn't work with blended data sources and there are various limitation of using LOD along with blended data sources. Therefore in order to provide some solution/workaround we need your data/twbx.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Find count in blended source

1. Re: Find count in blended source

2. Re: Find count in blended source

3. Re: Find count in blended source

4. Re: Find count in blended source

5. Re: Find count in blended source

6. Re: Find count in blended source

Actions

More Like This