Is there a way to find out the datasource of the fields in the visulalizations. I have loaded multiple datasets for one app. For example in the table object below the total attendees measure = Count(attendeenum), the attendeenum field is in multiple datasets .
Date | Total Attendee
Sep-2018 2000
Oct 2018 1000
How can I know which dataset the field is coming from? I tried to look in the properties panel but I do not see any field which displays which dataset the field comes from. Can someone please help.
This is not possible. This is why developers always note the source in the name. For example, when you load a dataset from SAP, like a sales table we name it QSLSXX_SAP_ATTENDEENUM. This way we always know what the source is.
I recommend to also do this, although this can take some work if you haven't done this from the start. But this will save you a big headache 😉
There is nothing native in the product that will give you this info. However an excellent third party product is NodeGraph https://www.nodegraph.se/ which does provide field level lineage.
An alternative but similar solution to @JordyWegman suggestion is to create a row source to tabel.
Transaction: Load Date, Atendeee, 'SAP' as TransactionSource From SAPSource ; Concatenate Load Date, Atendeee, 'HubSpot' as TransactionSource From hubSpotSource ;
Then you could make a selection in the transaction Source to investigate the impact of each source.
