Forum Discussion

Massig's avatar
Massig
Frequent Visitor
7 years ago

Merging two visualizations into one

I have 2 tables ... (data is coming from 2 data sets linked) One where I have CUSTOMER NAME / FIRST ACTIVITY / ACTIVITY TYPE / LAST ACTIVITY / ACTIVITY TYPE   and a second matrix visualization C...
Need Help
Massig's avatar
Massig
Frequent Visitor
7 years ago

Hi

thanks for your help.

I have got 2 tables behind the visualizations which I linked by company.

What I can't get to work is the visualization...

SOme pics..

These are the linked table

Then there is the visualization 1 - which is company plus first / last activity done coming from Member status update date and subtype

And visualization 2 - which is company plus activity by Ctype

I don't seem to be able to make one visualization with 

Company + first activity + subtype + Last activity + Subtype + the matrix with all the campaign and the count of campaign by company - ie. literally joining the 2 into 1.

SO it kind of looks like this

 

Thanks!

 

 

 

 

 

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Massig ,

Will have error message if you drag the fields in the visual 1to the visual 2?

To be more helpful, please share the data sample which could rerproduce youer scenario so that I could have a test on it.

Best  Regards,

Cherry