On one of my dashboards, one KPI pulls from one local_user_id, while the other ones pulls from another tables local_user_id. How do we link these so we just have one filter?

Hi Doug, I am sorry but I must admit I’m not sure if I understand. Could you please provide some further clarification regarding what is the issue here exactly? Feel free to involve screenshots if it helps. Thanks

Hey Doug, These are two separate attributes, even though their names are similar or the same, we are still speaking about two separate objects. You can certainly connect tables within your model, but that wouldn’t merge these attributes into one object, if this is what you are looking for.

Not trying to merge into one object

I assume that you are speaking about the Filtered Variable, correct? Unfortunately, you’d still need to create a separate variable for each attribute and its values. One variable cannot control multiple attributes at once.

Hi Doug, If you have logically the same attribute in multiple datasets (as several separate attributes), and want to filter them with one filter, you can create a new dataset, move one of these attributes there and mark it as a primary key. Then replace the other attributes by a reference to this newly created dataset. I would recommend checking this article: https://university.gooddata.com/tutorials/data-modeling/logical-data-model-basic-rules-of-data-modelling/ specifically the point 3. Just make sure you do not introduce an alternate path between other datasets by this change as described in point 5. of that article. And also be careful when replacing those attributes if you are already using them (in that case maybe first add the reference, update your metrics/visualizations and only then remove the original attributes).

Ok thanks. Though I don't understand why the main local_user_id on the cases table does not filter the sidd_oeprations table.

Are those tables connected in your model? For it to filter, there would need to be an arrow (either direct or through another table) from “cases” table to “ssid_operations” table.

I thought they were, in further investigation they are not - thanks