Hello All,
I have data from 2 universes that only have 1 similar data points. I want to merge the 2 then filter out to show what is “Moniotred” then show of those What each’s “Use Case” they are form the 2nd universe.
Example:
Universe 1:
Common ID
Status
Example below----->
Common ID Status
AKS20010 Not Monitored
ALBGNMM04001 Monitored
ALBGNMM04002 Monitored
ALBGNMM04003 Monitored
ALBGNMM04004 Monitored
ALBGNMM04501 Monitored
ALBGNMM04502 Monitored
ALBGNMM19181 Monitored
ANCHAKM54190 Monitored
ANCHAKM54900 Not Monitored
ANCHAKM54901 Not Monitored
ANCHAKM54902 Not Monitored
ANCHAKM54903 Not Monitored
ANCHAKM54904 Monitored
ANCHAKM54905 Monitored
Universe 2:
CTS Common ID
Equipment Use Case
Example------>
CTS Common ID Equipment Use Case
121212QWQWQW Indoor 3G Cov/Cap (UC3)
131970 Indoor 3G (UC1)
268743 UCT Indoor MultiStandard (UC5)
271598 UCT Indoor 3G Cov/Cap (UC3)
282238TEST1 Indoor 3G Cov/Cap (UC3)
AKS20010 Outdoor 4G - Capacity (UC4b) AP/design
ALBGNMM00040 Indoor 3G Cov/Cap (UC3)
ALBGNMM00044 Indoor 3G Cov/Cap (UC3)
ALBGNMM00050 Indoor 3G Cov/Cap (UC3)
ALBGNMM00051 Indoor 3G Cov/Cap (UC3)
ALBGNMM00052 Indoor 3G Cov/Cap (UC3)
ALBGNMM00053 Indoor 3G Cov/Cap (UC3)
ALBGNMM00054 Indoor 3G Cov/Cap (UC3)
ALBGNMM00055 Indoor 3G Cov/Cap (UC3)
ALBGNMM00157 Indoor 3G Cov/Cap (UC3)
ALBGNMM00162 Indoor 3G Cov/Cap (UC3)
ALBGNMM00163 Indoor 3G Cov/Cap (UC3)
ALBGNMM00165 Indoor 3G Cov/Cap (UC3)
ALBGNMM00166 Indoor 3G Cov/Cap (UC3)
ALBGNMM00167 Indoor 3G Cov/Cap (UC3)
ALBGNMM00168 Indoor 3G Cov/Cap (UC3)
In the end I want to show only the “Monitored” sites with their relative “Use Case” next to them in a column or Pie chart format.
What would I need to do to display that?
Thank you
njohnson99 (BOB member since 2016-01-13)