6 Replies Latest reply on Sep 20, 2016 7:51 AM by David Li

    Troubleshoot applying filter with multiple data sources

    Clara Gonzalez Ginestet

      Troubleshoot: Applying filter after blending multiple data sources

       

      I blended data from RedShift and GA to build a dashboard, which shows the active users of the different products by country of the last 30 days. The multiple sources are linked. However, when I want to apply filter, the value of the data showed is wrong.

       

      Thnaks in advance for your help

       

      For example,

      The summary table shows the value of country by product. Those values are correct.

      p.png

       

      However, when I add date, the values are messed up.

      v2.png

       

       

      Ultimately, we want to remove country and use it as a filter as it’s the goal of this dashboard. But, the data doesn’t show the correct values. CR is a good example of the issue.

       

      v3.png

       

       

       

      Note: The measure used is a field that connects all the data sources (daily, Tigo Money App and Tigo Sport App) using to build this dashboard.

       

      zn(SUM([Active Users]))+zn(SUM([Tigo Sports App (TigoSports App)].[Active Users]))+zn(SUM([Daily].[Active Users]))

       

      Mensaje editado por: Clara Gonzalez Ginestet

       

      Mensaje editado por: Clara Gonzalez Ginestet