Date Problem

[Anonymous]

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:

[sunny_talwar]

If you have already selected Year and Month, I don't think you would need Set analysis:

Count(CLIENT)

[Anonymous]

No... CLIENT and CALENDAR are joined by YEAR_MONTH.

With month selected and count(CLIENT) my chart will show:

• DAY from CALENDAR as Dimension: the same count value all days from the month
• DAY extracted from INCLUSION_DATE as Dimension: how many CLIENT was added in each day.

And what i want is: how many CLIENT i have until each day.

[Anonymous]

count(

{

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

}

CLIENT)

[Kushal_Chawda]

count(

{

  <INCLUSION_DATE={"<=$(=max(DATE))"}, Month=>

}

CLIENT)

[Anonymous]

Putting "Month=" the chart shows all dates from selected year.

Putting max(DATE) the chart shows, for all dates, the same value, the value of the max date: 31/12/2016

[Anonymous]

Putting max(DATE) the chart shows, for all dates, the same value, the value of the max date: 31/03/2016

[Anonymous]

Can you share your app?

Thanks!

[Anonymous]

thats my app!

Thanks to all for your support!

[sunny_talwar]

Can you check your sample. The YEAR_MONTH and INCLUSION_DATE are not aligning up properly here