Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I created a calendar, and I added a filter in my application with the dates of this calendar.
I wish use calendar dates as a filter for my data.
For example if the user chose the 01/01/2017 I have the sales of 01/01.
How do I proceed?
I think I have to use a variable but I do not know how
Someone can help me please ?
What is the issue you are facing?
Do you want to display Sales of that selected Date?
Then you can try
Sum({<Date = {"$(=Max(Date))"}>} Sales)
No
in fact I want to select a period of activity.
Example: Sale between 01/01/17 - 03/03/17
in Filter , you can search >=01/01/17<=03/03/17 and press Enter.
It will select all dates in between those 2.
Make sure that you give input in correct date format.
It's a very good idea.
But I wanted to use two filters StartDate, EndDate.
I will offer it to my manager if I can not find it.
If you are using 2 filters then you can try
Sum({<Date = {">=$(=Max(StartDate))<=$(=Max(EndDate))"}>} Sales)
may be in calendar create field like
day(date_field) as day
and use it as filter