IDEA
|
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.
... View more
06-10-2024
08:12 AM
|
1
|
0
|
222
|
POST
|
It just dawned on me but another solution would be to use Labeling in addition to using arcade which might be a better option.
... View more
06-07-2024
08:21 AM
|
0
|
0
|
286
|
IDEA
|
@RPGISNothing happens in 3.3 when I try this. The scroll wheel does nothing I can see.
... View more
05-31-2024
08:19 AM
|
0
|
0
|
83
|
POST
|
There is this option as well. I completely forgot about it last time, but it might be what you are actually looking for.
... View more
05-28-2024
05:40 AM
|
0
|
0
|
563
|
IDEA
|
Was this ever done? Surprised it's not a thing, seems like we have a community for everything except this.
... View more
05-23-2024
08:52 AM
|
0
|
0
|
384
|
POST
|
You can see in those release notes that GroupBy was added at 1.8, and would be in a 10.9.1 deployment. https://developers.arcgis.com/arcade/guide/version-matrix/ If you are in an older version, the functions simply don't exist. When you see them listed as "unavailable", it means that the function isn't compatible with the particular profile your expression is being used in. https://developers.arcgis.com/arcade/profiles/ Not all Arcade contexts are created equal. If you're writing an expression for symbology or something, you can only access a single feature's attributes, and you won't be able to do "broader" functions that involve entire layers.
... View more
05-23-2024
06:51 AM
|
1
|
0
|
302
|
POST
|
Can you please post your code so that the community can help you troubleshoot it? Otherwise, it would be nearly impossible to help you with your issue.
... View more
05-23-2024
04:32 AM
|
0
|
0
|
202
|
POST
|
Hi, I am trying to figure out a way to set up a countdown that automatically refreshes after opening a dashboard? The code below works fine but it isn't synced with the layer refresh. I am curious if anyone knows a way to have the countdown refresh the same time the layer refreshes. var setmin = 4-(Minute(Now())%5)
var setsec = Text(60-second(Now()))
if(count(setsec)==1){setsec='0'+setsec}
var timer = Text(setmin)+':'+Text(setsec) I know you can turn on the last updated option on any of the widgets, but I would like to have a larger indicator showing that.
... View more
05-21-2024
10:29 AM
|
0
|
0
|
260
|
POST
|
Hi, I am trying to figure out a way to set up a countdown that automatically refreshes after opening a dashboard? The code below works fine but it isn't synced with the layer refresh. I am curious if anyone knows a way to have the countdown refresh the same time the layer refreshes. var setmin = 4-(Minute(Now())%5)
var setsec = Text(60-second(Now()))
if(count(setsec)==1){setsec='0'+setsec}
var timer = Text(setmin)+':'+Text(setsec) I know you can turn on the last updated option on any of the widgets, but I would like to have a larger indicator showing that.
... View more
05-21-2024
10:23 AM
|
0
|
0
|
229
|
POST
|
Hi @jamierodriguez, You can specify the distance from a selected feature by either clicking on the feature in the map (if you want to interactively specify the feature/record) or in the select feature by location dialogue box you can specify the feature and modify the search distance from another feature.
... View more
05-21-2024
09:48 AM
|
0
|
0
|
278
|
POST
|
Related idea: Use unregistered database view in attribute rule
... View more
05-13-2024
07:07 AM
|
0
|
0
|
501
|
POST
|
You do not need to use the datetime.strptime() function since python will automatically convert a datetime python object to a sql datetime object when you specify the actual datefield. from datetime import datetime
Sample = datetime.now().isoformat(timespec='seconds')
print( Sample )
#printed result = '2024-05-13T08:42:27' .
... View more
05-13-2024
05:44 AM
|
0
|
0
|
245
|
POST
|
@EllenLester I didn't end up finding a way to do this. If you find one I'd love to hear about it!
... View more
05-02-2024
11:49 AM
|
0
|
0
|
298
|
POST
|
I've made headway on the left outer join and have run into what seems to be a one-to-many, or many-to-one(?) relationship issue. Each record in the database is a distinct license, but each license is associated with one, or more license types. Now, with the left outer join, I'm duplicating records that have multiple types. I would like to maintain the distinct license information and somehow aggregate the additional license types to that record instead of creating the duplicates. I've looked at the group by function, but I'm not sure that's really what I'm after. Do you have any suggestions? Thanks!
... View more
05-01-2024
01:28 PM
|
0
|
0
|
420
|
Title | Kudos | Posted |
---|---|---|
2 | 09-13-2024 08:30 AM | |
1 | 09-13-2024 03:41 PM | |
2 | 08-12-2024 06:46 AM | |
1 | 08-06-2024 01:13 PM | |
1 | 08-06-2024 01:06 PM |