1 Reply Latest reply on Sep 17, 2018 1:23 PM by Fisseha Berhane

    filter a map by dimensions while using LOD with blended data

    Fisseha Berhane

      I have two tables: (1) designated market area(DMA) which contains data for mapping the USA at DMA level,  (2) a second table that measures and dimensions at the DMA level. I could not join them because the data size explodes. So, I want to use data blending. I have LOD expressions as shown in the attached workbook. The map works fine but when I try to add a dimension to be used as filter, it fails. In the attached workbook, I want to add 'Site' and 'Market Name' as filters where the user can choose and the map should update based on the selection. Any help highly appreciated.