1 Reply Latest reply on Jan 18, 2017 5:04 PM by diego.medrano

    How to create an auxiliar datasource with distinct dates

    Eduardo Perea

      Hi,

       

      I want to control several datasources by filtering by date.

      Problem is that I can join them as the measures will get messed up. So I thought I could create a new table with the lsit of dates and join it to the other data sources so that I would be able to control them creating a filter.

       

      This date table will have the rows calculated by something like DISTINCT(datecolumn_of_the_datasource)

       

      How can I do this?

       

      Thanks