Community
Select to view content in your preferred language

More date filter options for maps and applications

146
0
06-10-2024 08:12 AM
Status: Open
RPGIS
by
Regular Contributor

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"><span style="font-size:36px"><span style="color:#ffffff"><strong>{expression/M}</strong></span></span></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}"><strong>Sunday</strong></th>
			<th style="background-color:{expression/W}"><strong>Monday</strong></th>
			<th style="background-color:{expression/W}"><strong>Tuesday</strong></th>
			<th style="background-color:{expression/W}"><strong>Wednesday</strong></th>
			<th style="background-color:{expression/W}"><strong>Thursday</strong></th>
			<th style="background-color:{expression/W}"><strong>Friday</strong></th>
			<th style="background-color:{expression/W}"><strong>Saurday</strong></th>
		</tr>
	</tbody>
	<tbody>
		<tr>
			<td style="background-color:{expression/0T}; text-align:center">
			<p><strong>{expression/0}</strong></p>
			</td>
			<td style="background-color:{expression/1T}; text-align:center">
			<p><strong>{expression/1}</strong></p>
			</td>
			<td style="background-color:{expression/2T}; text-align:center">
			<p><strong>{expression/2}</strong></p>
			</td>
			<td style="background-color:{expression/3T}; text-align:center">
			<p><strong>{expression/3}</strong></p>
			</td>
			<td style="background-color:{expression/4T}; text-align:center">
			<p><strong>{expression/4}</strong></p>
			</td>
			<td style="background-color:{expression/5T}; text-align:center">
			<p><strong>{expression/5}</strong></p>
			</td>
			<td style="background-color:{expression/6T}; text-align:center">
			<p><strong>{expression/6}</strong></p>
			</td>
		</tr>
		<tr>
			<td style="background-color:{expression/7T}; text-align:center">
			<p><strong>{expression/7}</strong></p>
			</td>
			<td style="background-color:{expression/8T}; text-align:center">
			<p><strong>{expression/8}</strong></p>
			</td>
			<td style="background-color:{expression/9T}; text-align:center">
			<p><strong>{expression/9}</strong></p>
			</td>
			<td style="background-color:{expression/10T}; text-align:center">
			<p><strong>{expression/10}</strong></p>
			</td>
			<td style="background-color:{expression/11T}; text-align:center">
			<p><strong>{expression/11}</strong></p>
			</td>
			<td style="background-color:{expression/12T}; text-align:center">
			<p><strong>{expression/12}</strong></p>
			</td>
			<td style="background-color:{expression/3T}; text-align:center">
			<p><strong>{expression/13}</strong></p>
			</td>
		</tr>
		<tr>
			<td style="background-color:{expression/14T}; text-align:center">
			<p><strong>{expression/14}</strong></p>
			</td>
			<td style="background-color:{expression/15T}; text-align:center">
			<p><strong>{expression/15}</strong></p>
			</td>
			<td style="background-color:{expression/16T}; text-align:center">
			<p><strong>{expression/16}</strong></p>
			</td>
			<td style="background-color:{expression/17T}; text-align:center">
			<p><strong>{expression/17}</strong></p>
			</td>
			<td style="background-color:{expression/18T}; text-align:center">
			<p><strong>{expression/18}</strong></p>
			</td>
			<td style="background-color:{expression/19T}; text-align:center">
			<p><strong>{expression/19}</strong></p>
			</td>
			<td style="background-color:{expression/20T}; text-align:center">
			<p><strong>{expression/20}</strong></p>
			</td>
		</tr>
		<tr>
			<td style="background-color:{expression/21T}; text-align:center">
			<p><strong>{expression/21}</strong></p>
			</td>
			<td style="background-color:{expression/22T}; text-align:center">
			<p><strong>{expression/22}</strong></p>
			</td>
			<td style="background-color:{expression/23T}; text-align:center">
			<p><strong>{expression/23}</strong></p>
			</td>
			<td style="background-color:{expression/24T}; text-align:center">
			<p><strong>{expression/24}</strong></p>
			</td>
			<td style="background-color:{expression/25T}; text-align:center">
			<p><strong>{expression/25}</strong></p>
			</td>
			<td style="background-color:{expression/26T}; text-align:center">
			<p><strong>{expression/26}</strong></p>
			</td>
			<td style="background-color:{expression/27T}; text-align:center">
			<p><strong>{expression/27}</strong></p>
			</td>
		</tr>
		<tr>
			<td style="background-color:{expression/28T}; text-align:center">
			<p><strong>{expression/28}</strong></p>
			</td>
			<td style="background-color:{expression/29T}; text-align:center">
			<p><strong>{expression/29}</strong></p>
			</td>
			<td style="background-color:{expression/30T}; text-align:center">
			<p><strong>{expression/30}</strong></p>
			</td>
			<td style="background-color:{expression/31T}; text-align:center">
			<p><strong>{expression/31}</strong></p>
			</td>
			<td style="background-color:{expression/32T}; text-align:center">
			<p><strong>{expression/32}</strong></p>
			</td>
			<td style="background-color:{expression/33T}; text-align:center">
			<p><strong>{expression/33}</strong></p>
			</td>
			<td style="background-color:{expression/34T}; text-align:center">
			<p><strong>{expression/34}</strong></p>
			</td>
		</tr>
		<tr>
			<td style="background-color:{expression/35T}; text-align:center">
			<p><strong>{expression/35}</strong></p>
			</td>
			<td style="background-color:{expression/36T}; text-align:center">
			<p><strong>{expression/36}</strong></p>
			</td>
			<td style="background-color:{expression/37T}; text-align:center">
			<p><strong>{expression/37}</strong></p>
			</td>
			<td style="background-color:{expression/38T}; text-align:center">
			<p><strong>{expression/38}</strong></p>
			</td>
			<td style="background-color:{expression/39T}; text-align:center">
			<p><strong>{expression/39}</strong></p>
			</td>
			<td style="background-color:{expression/40T}; text-align:center">
			<p><strong>{expression/40}</strong></p>
			</td>
			<td style="background-color:{expression/41T}; text-align:center">
			<p><strong>{expression/41}</strong></p>
			</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.