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
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi thinkvisual 

I am not sure I am following.

Anyhow, there is no prevention to use multiple sources in one visual.

Yes, it is important/crucial to have your relationship(s) in place.

Good luck!
A

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