Is there a function that checks the name of a list item in a module and returns specific data?
Hello, I am trying to build a UX dashboard that displays data from two different modules. In D01 Slots (PAGES: Version, Locations, Resource Groups, and Teams. COLUMNS: Time. ROWS: Product Names and one line item "Slots"). Module D01 allows me to see the number of slots each product uses. In D02 (PAGES: Version, Locations, Resource Groups. COLUMNS: Time. ROWS: Product Names and a few line items, the most important being "Planned Capacity". In the UX, I want make a chart that shows all the slots used by each product in D01 but also plotting "Planned Capacity" from D02. I've tried many things, but I just can not figure it out. I was wondering if there was a function that check the name of a list item and returns data based on the name. For example, in the list "Product Names" that both D01 and D02 use as a row dimension, there are items called "CAPACITY" that I would like to carry the data from D02 to display on the graph. I've come up with