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

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi thinkvisual 

      I advise you to try. See what happens. Experiemnet things. Try and error.

      That's the way to learn new things. After that return with focused questions.

      The questions you have are very basic and not clear to me what your issues are, if any.

      I am not aware of any limitations in the # of calculated columns per source.

      I have sources with 10+ such columns.

      Good luck!
      A