07-07-2017 09:22 AM
I'm working on a report in SAS Visual Analytics in the Report designer using two different data sources A and B. I've already created an aggregate measure based on a measure of A and another one based on a measure of B. Does anyone know if it is possible to create another aggregate measure based on these two aggregate measures? My problem is that they come from different data sources.
It would be really helpful.
07-07-2017 12:56 PM
You would have to join the underlying data before adding it to SAS Visual Analytics to use both in the same calculation.
07-10-2017 11:05 AM
Many thanks for helping. Unfortunatelly, I can't do that because after joining the data other issues come up when filtering the data through drop-down lists in SAS Visual Analytics.
07-11-2017 07:15 AM - edited 07-11-2017 07:16 AM
Thanks for your answer. The other issues are not properly related to SAS Visual Analytics but with the way the data would be displayed after a previous join, which doesn't help me then in SAS VA. That's why I didn't give details about it. It was just to explain that the first post describes what I really needed.