More date filter options for maps and applications

RPGIS — Mon, 10 Jun 2024 15:12:33 GMT

Hi,

I am trying to filter data to the best of my abilities, but I cannot seem to find a way to filter dates to filter the first day of the month, beginning week of the month, first day of the week, specific days (Friday, Saturday,etc.) or even enable arcade filters for specific criteria. The reasoning for this is I am trying to create a dynamic calendar

var N = TextFormatting.NewLine var T = Today() var StartMDay = Date(Year(T),Month(T),1) var LastMDay = DateAdd(StartMDay,1,'Month') LastMDay = DateAdd(LastMDay,-1,'day') var CS = DateAdd(StartMDay,-WeekDay(StartMDay),'day') var CE = DateAdd(LastMDay,6-WeekDay(LastMDay),'day') var InspDate = $datapoint.InspectionDate var InspCnt = $datapoint.InspectCount var Calendar = { '0': Day(CS) } for(var i = 1; i<42;i++){ var CD = Day(DateAdd(CS,i,'day')) if(CD==Day(T)){ Calendar[Concatenate(i,'T')]='#92a9db' } Calendar[Text(i)] = CD } Calendar['M'] = Text(T,'MMMM') Calendar['W'] = '#4472C4' return { textColor: 'Black', backgroundColor: '', separatorColor:'', selectionColor: '', selectionTextColor: '', attributes: Calendar }

Html/css code

<table border="1" cellpadding="12%" cellspacing="1" style="background-color:#4472c4; width:100%"> <tbody> <tr> <td style="text-align:center">{expression/M}</td> </tr> </tbody> </table> <table border="1" cellpadding="30%" cellspacing="0" style="background-color:#d9e1f2; border-collapse:collapse; width:100%"> <tbody> <tr> <th style="background-color:{expression/W}">Sunday</th> <th style="background-color:{expression/W}">Monday</th> <th style="background-color:{expression/W}">Tuesday</th> <th style="background-color:{expression/W}">Wednesday</th> <th style="background-color:{expression/W}">Thursday</th> <th style="background-color:{expression/W}">Friday</th> <th style="background-color:{expression/W}">Saurday</th> </tr> </tbody> <tbody> <tr> <td style="background-color:{expression/0T}; text-align:center"> {expression/0} </td> <td style="background-color:{expression/1T}; text-align:center"> {expression/1} </td> <td style="background-color:{expression/2T}; text-align:center"> {expression/2} </td> <td style="background-color:{expression/3T}; text-align:center"> {expression/3} </td> <td style="background-color:{expression/4T}; text-align:center"> {expression/4} </td> <td style="background-color:{expression/5T}; text-align:center"> {expression/5} </td> <td style="background-color:{expression/6T}; text-align:center"> {expression/6} </td> </tr> <tr> <td style="background-color:{expression/7T}; text-align:center"> {expression/7} </td> <td style="background-color:{expression/8T}; text-align:center"> {expression/8} </td> <td style="background-color:{expression/9T}; text-align:center"> {expression/9} </td> <td style="background-color:{expression/10T}; text-align:center"> {expression/10} </td> <td style="background-color:{expression/11T}; text-align:center"> {expression/11} </td> <td style="background-color:{expression/12T}; text-align:center"> {expression/12} </td> <td style="background-color:{expression/3T}; text-align:center"> {expression/13} </td> </tr> <tr> <td style="background-color:{expression/14T}; text-align:center"> {expression/14} </td> <td style="background-color:{expression/15T}; text-align:center"> {expression/15} </td> <td style="background-color:{expression/16T}; text-align:center"> {expression/16} </td> <td style="background-color:{expression/17T}; text-align:center"> {expression/17} </td> <td style="background-color:{expression/18T}; text-align:center"> {expression/18} </td> <td style="background-color:{expression/19T}; text-align:center"> {expression/19} </td> <td style="background-color:{expression/20T}; text-align:center"> {expression/20} </td> </tr> <tr> <td style="background-color:{expression/21T}; text-align:center"> {expression/21} </td> <td style="background-color:{expression/22T}; text-align:center"> {expression/22} </td> <td style="background-color:{expression/23T}; text-align:center"> {expression/23} </td> <td style="background-color:{expression/24T}; text-align:center"> {expression/24} </td> <td style="background-color:{expression/25T}; text-align:center"> {expression/25} </td> <td style="background-color:{expression/26T}; text-align:center"> {expression/26} </td> <td style="background-color:{expression/27T}; text-align:center"> {expression/27} </td> </tr> <tr> <td style="background-color:{expression/28T}; text-align:center"> {expression/28} </td> <td style="background-color:{expression/29T}; text-align:center"> {expression/29} </td> <td style="background-color:{expression/30T}; text-align:center"> {expression/30} </td> <td style="background-color:{expression/31T}; text-align:center"> {expression/31} </td> <td style="background-color:{expression/32T}; text-align:center"> {expression/32} </td> <td style="background-color:{expression/33T}; text-align:center"> {expression/33} </td> <td style="background-color:{expression/34T}; text-align:center"> {expression/34} </td> </tr> <tr> <td style="background-color:{expression/35T}; text-align:center"> {expression/35} </td> <td style="background-color:{expression/36T}; text-align:center"> {expression/36} </td> <td style="background-color:{expression/37T}; text-align:center"> {expression/37} </td> <td style="background-color:{expression/38T}; text-align:center"> {expression/38} </td> <td style="background-color:{expression/39T}; text-align:center"> {expression/39} </td> <td style="background-color:{expression/40T}; text-align:center"> {expression/40} </td> <td style="background-color:{expression/41T}; text-align:center"> {expression/41} </td> </tr> </tbody> </table>

I would like for the ability to filter the data as dynamically as possible which would open up a lot more opportunities.

idea More date filter options for maps and applications in ArcGIS Online Ideas

More date filter options for maps and applications