filter the date

[bhagi]

Hi all,

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/2019 I have the sales of 01/01.

How  can i get? 

thanks 

bhagi

[avinashelite]

Link your data table and calendar with the date key and add the filter in the front end app .....not sure what your looking for !!

[Chanty4u]

hi,

what is your expected output? and how  you want to show?

if you want like below

may be in calendar create field like

day(Yourdate) as day

and use it as filter

[Chanty4u]

or may be

Do you want to display Sales of that selected Date?

Then you can try

Sum({<Date = {"$(=Max(Date))"}>} Sales)