13 Replies Latest reply: Jun 6, 2016 1:28 PM by Danilo Torres RSS

    Date Problem

    Danilo Torres

      Hi guys, my problem is:

       

      • I have two tables: CLIENT and CALENDAR
      • They are joined by YEAR_MONTH
      • CLIENTE has a column called: INCLUSION_DATE
      • In CALENDAR i have YEAR_MONTH, YEAR, MONTH, DAY, DATE

       

      I would like to select YEAR=2016, MONTH=MAR and create a line chart that give me how many CLIENTs i have day by day of the whole selected month, from the day 1 to the 30.

       

      My set analisys was:

       

      count(

      {

        <INCLUSION_DATE={'<=$(=DATE)'}>

      }

      CLIENT)

       

      It works when i select just one DATE. But when i select the month the chart show me nothing.

       

      My expectation is someting like this:

      image1.png