Forum Discussion

thinkvisual's avatar
thinkvisual
Frequent Visitor
7 years ago

Adding together multiple different data sources

Hi there,   I am trying to add up multiple sources of data to put into one visual as shown below, for example impressions from mulitple sources, or engagement from multiple sources. But not sure ho...
Need Help
thinkvisual's avatar
thinkvisual
Frequent Visitor
7 years ago

Anonymous To simplify my question: how can I combine 4+ fields from different data sources?

I thought a quick measure was for a max of 2 items - and a custom column works per table of data from each uploaded XLS sheet(?) My data is coming from multiple XLS sheets as shown in the picture.

 

Many thanks

David

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi thinkvisual 

Again, I am not following.

Maybe give samples of your data and the required results?!

You need to define the relationships between the tables in your data model.

Then just use the columns whereever you wish.

Thanks,

A

  • thinkvisual's avatar
    thinkvisual
    Frequent Visitor
    7 years ago

    Hi Anonymous  - thank you for the fast reponse!

    Honestly dont know how I can be any clearer than the pink mark up on the image above.

    I'm trying to add those fields together to put in the top bar of the funnel

    (they are connected by date in the data model)

    Many thanks 

    David

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi thinkvisual ,

      What happens when you drag and drop the fields?

      Cheers

      A

      • thinkvisual's avatar
        thinkvisual
        Frequent Visitor
        7 years ago

        Hi Anonymous 

        I believe you can only drop in one field per bar

        I will also need to accumulate data for other visuals – which  makes me believe this definitely requires a calculation.

        Am I correct in thinking that a calculated column is per source – so for eample in the image below, I could have one column for CRM, one for FB Accounts, one for posts, or can it bring together fields from across all three?

        Many thanks

        David