Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys, my problem is:
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:
If you have already selected Year and Month, I don't think you would need Set analysis:
Count(CLIENT)
No... CLIENT and CALENDAR are joined by YEAR_MONTH.
With month selected and count(CLIENT) my chart will show:
And what i want is: how many CLIENT i have until each day.
count(
{
<INCLUSION_DATE={'<=$(=Max(DATE))'}>
}
CLIENT)
count(
{
<INCLUSION_DATE={"<=$(=max(DATE))"}, Month=>
}
CLIENT)
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
Putting max(DATE) the chart shows, for all dates, the same value, the value of the max date: 31/03/2016
Can you share your app?
Thanks!
thats my app!
Thanks to all for your support!
Can you check your sample. The YEAR_MONTH and INCLUSION_DATE are not aligning up properly here