5 Replies Latest reply on Dec 13, 2017 8:59 PM by swaroop.gantela

    Substitution of Parameter with Level of Detail

    Natalia Harty

      Hi all,

      It seemed like I found a solution few weeks ago but the workbook and requirements are growing and the former solution doesn't work any more.

       

      Attached is a sheet that is a part of a dashboard. The dashboard now has an additional chart (with call type codes) that is used as a filter for the rest of the dashboard. When I click at any type in the "Filter" chart I loose the comparison in the attached chart yet I still want to see the attached comparison for specific calls.

       

      Recently I learned about Level of Detail and am wondering if I can build the exact replica of the attached chart, using LOD. So far i cannot overcome the fact that I need to create additional measures for each measure name and as a result I cannot present the data as an overlapping chart.

       

      Please push me in the right direction.

       

      Thanks,