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:
Thanks sunny.
These two fields represent different things:
Your uploaded document shows something else than what you mentioned in your OP. A flat line from day one. This is to be expected as the granularity of your key connectiing Calendar to Client is at the month level, meaning that it produces the same set of clients for every day in a month. Can you add the actual date to the key and let the calendar decide on what granularity to use?
Also from your original picture it seems like you want to accumulate the number of clients. Take that into account when setting the expression properties.
Best,
Peter
Also keep in mind that set analysis produces a reduced/expanded data set before the object/chart is recalculated and not a different set row-by-row in your table or chart. This accounts for your initial problem whereby the chart works for a single date (field DATE in set analysis returns a single value) and not for any other selection (DATE returns multiple values which translates to NULL in the $-substitution expression). Result: no INCLUSION_DATE matches the condition.
Best,
Peter
Yeah Peter! Thanks for your attention and response.
And thats the point, the granularity. But as this change will take me a hard work (my app is not only that a sent. That are a lot of others tables in my cloud). So changing this join from CLIENT to CALENDAR will broken all of my app.
Thats the reason i'm trying to implement that vision by day using set analisys.
Thanks