I'm trying to get Tableau to display one value of a variable together with three coresponding values from the same variable, then I need to do calculations on the filtered values from another data source.
The data structure looks like this:
For KMT_AKTION_ID 1115 there should be displayed KMT_AKTION_ID_ANZEIGE 744,763,954 and 1115.
This is stored in the datasource KMTKR_MCB1.0_Anzeige_Vorangegangen
On the KMT_AKTION_ID is more data in another datasource: KMTKR_MCB1.0_Erhaltungen
I did make the scenario work with this setup:
The main data source is KMTKR_MCB1.0_Anzeige_Vorangegangen, there I create a parameter aktions_name which is in the aktions_name filter with [AKTIONS_NAME]=[Parameter AKTIONS_NAME]. Then I display Aktions_Name_Vorangegangen.
I define the join between the two data sources:
Now the parameter works as a filter for the values and the sum's from the other datasource is correctly displayed.
The huge problem which I'm unable to solve after a few hours:
In tableau I can only count distinct ( COUNTD ) from the main data source.
In the main datasource now is only the strucure as seen above, but the data is ONLY in the other datasource!
So what I need to have, is a seperate data source in which I can make the parameter and filter work by themselves, what I tried is joining the KMTKR_MCB1.0_Anzeige_Vorangegangen data on KMTKR_MCB1.0_Erhaltungen in a new dataset, but now the relationship between aktions_name_anzeige and aktions_name does not work anymore ( even with the join defined.. ), with my parameter setting I only have the filtered value avaliable for tableau and only this is shown.
Has anybody dealt with something similar? Any help is appreciated!
You mention joining the data but the view and the issue described relate to using a Data Blend. Is it possible to actually join the data?