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:
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:
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.
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