Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- About JayJohnsonWashoeCounty
JayJohnsonWasho
Frequent Contributor
since
12-14-2017
01-13-2023
429
Posts created
216
Kudos given
26
Solutions
669
Kudos received
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
My Ideas
(29 Idea Submissions)Latest Contributions by JayJohnsonWashoeCounty
|
IDEA
|
@AdamMiller4 Nope, still making charts in Dashboard and then embedding in Experience Builder
... View more
12-15-2021
08:39 AM
|
0
|
0
|
1227
|
|
POST
|
Is it possible to create a SQL View of a feature layer that is essentially an "on the fly" dissolve? I have a polygon layer of fire response districts in which many small polygons are all the responsibility of a single station. Rather than creating a derivative layer (which I then have to maintain) by dissolving on the "station" attribute, it would be great to have a view of this layer in which each unique "station" value has only a single multi-part polygon. I'm not sure whether this is something that can be done with a view... Thanks.
... View more
12-03-2021
11:02 AM
|
0
|
2
|
3430
|
|
POST
|
Okay, this was very odd. As mentioned, every time I updated the symbology in the Dispatcher map it kept reverting to the old symbology the next time I looked at it (I know that sounds impossible...or at least improbable). Finally, by changing the Assignments to a different attribute in Classic Map Viewer, saving that, THEN changing the symbology back to Status I was able to customize and save the symbology I wanted. Not sure why this was acting up, but all good for now.
... View more
12-01-2021
03:29 PM
|
0
|
0
|
1336
|
|
POST
|
While the FeatureSet code suggested by @DominicRobergeIADOT looks promising, I couldn't make it work for me. Instead I created a SQL view that somewhat creatively uses a calculated field "fakeDate" to push all the data into a single arbitrary year (1,000 AD to avoid potential confusion with any "real" datetime) and pushed the COVID New Cases for each year into separate attribute fields. I published this view in a service and using this approach I can show the different years as series on a single chart and "fakeDate" as the Category axis. SQL View table: Dashboard Serial Chart: SQL View definition is shown below: SELECT ROW_NUMBER() OVER(ORDER BY reportdt ASC) AS OBJECTID, reportdt, NewCases AS NewCases2020, null AS NewCases2021, DATEADD(year, -1020, reportdt) AS fakeDate FROM COVID_CASESTABLE WHERE (reportdt BETWEEN '2019-12-31' AND '2021-01-01') UNION ALL SELECT ROW_NUMBER() OVER(ORDER BY reportdt ASC) AS OBJECTID, reportdt, null AS NewCases2020, NewCases AS NewCases2021, DATEADD(year, -1021, reportdt) AS fakeDate FROM COVID_CASESTABLE WHERE (reportdt BETWEEN '2020-12-31'AND '2022-01-01') This might get a bit cumbersome if we end up tracking COVID for 10 years, but in the meantime this was a quick, relatively simple workaround, if admittedly involving a bit of smoke and mirrors...
... View more
12-01-2021
01:52 PM
|
0
|
0
|
1961
|
|
POST
|
I migrated a project to the "new" version of Workforce and now I seem unable to update the symbology for the Assignments. In the old version of Workforce I was able to open the Dispatcher Map and update the symbols used to show Assignment Status using an image to be more intuitive for the end user. Screen shot shows my old symbology, which worked fine in the old version. In the new, migrated version of the Workforce project I can Open the webmap in Classic Viewer and update the symbology to match this. After I save the map and exit, the next time I go into the map, the "generic, out of the box" symbology is back. Why are my symbology changes not sticking?
... View more
11-30-2021
07:52 AM
|
1
|
2
|
1410
|
|
POST
|
I'd like control over the x-axis in a Serial Chart where I have a Date field as the Category. The chart wants to only display the range of dates for which I have data. I'd like to be able to start the chart at Jan 1 and end it at Dec 30th, regardless of whether I have data values for that entire span of time. I can control the min and max for the Value axis, but not the Category axis. Any way to make this happen in Dashboard Serial Charts?
... View more
11-24-2021
09:28 AM
|
2
|
2
|
1060
|
|
POST
|
Adding a new Upcoming Events card did not change the behavior. Clicking on an event still opens a new tab. This behavior seems to be persistent across Initiatives.
... View more
11-18-2021
03:14 PM
|
0
|
0
|
826
|
|
POST
|
When I click on an Event in the "Upcoming Events Card" on my HUB initiative, the Event opens in a new page. The pre-configured Event "item" (for which I appear to have limited editing capability) contains a link to the original HUB site - when I click this link now I have TWO TABS open to the same HUB initiative. 1) Can I prevent the Event from opening in a new tab? (Force it to open in the same tab.) OR 2) Can I edit the Event item to remove the link back to the main HUB intitiative?
... View more
11-16-2021
07:58 AM
|
0
|
2
|
873
|
|
POST
|
Good suggestion - thanks for the code sample. I'll try this and report back.
... View more
11-10-2021
10:22 AM
|
0
|
0
|
2093
|
|
POST
|
I have a multi-year COVID dataset (# new cases per day). Currently this is displayed as a traditional time series, incrementing on the x-axis by day (see attachment TraditionalTimeSeries.JPG). I've been asked to now show this dataset in a way that allows the user to see potential seasonality, by having the x-axis as months and days (BUT NO YEAR) and the y-axis as the # New Cases per Day, regardless of year. In this way, the chart would show the number of new cases on each calendar day "superimposed" for both 2020 and 2021. I've attached a fairly ugly mock up of the concept (Seasonality.png). Any ideas on how I might accomplish this in Dashboard?
... View more
11-10-2021
08:43 AM
|
0
|
3
|
2151
|
|
POST
|
Thanks for the screen shot Kevin; I was able to put your in-line style code in the Footer's custom HTML area. However, I don't see any resultant change in stretching behavior in the Gallery: Is there another step to this method?
... View more
09-29-2021
08:06 AM
|
0
|
2
|
3927
|
|
POST
|
Doug, I was trying to stick with the web version of the survey designer, which doesn't give you that level of control. The Rating question type in particular looks great when created with the web version, but you are stuck with the field format of String. If you try to later edit that with Connect in order to change the field format to an Integer, the display of the question becomes less pleasing. "Rating" question from web designer: Appearance of same question after editing esribindtype to integer with Connect: Connect doesn't seem to handle the "Rating" question type in quite the same way as the online designer... So, under time pressure, I've just accepted that this is the way these questions have to look in order to get them to have an integer field type.
... View more
09-24-2021
09:25 AM
|
0
|
1
|
2970
|
|
POST
|
I've designed a Survey123 form with the online design form. I used the "Rating" widget to allow the user to rate an item from 1-5 stars. The resulting data is formatted as STRING, even though it only contains integer values. I'd like to display an AVERAGE rating value from this survey on a dashboard, but with the rating field formatted as STRING that isn't possible. Can I somehow re-cast this field as an integer (maybe in a view?) so that Dashboard can get an average from it?
... View more
09-23-2021
01:13 PM
|
0
|
5
|
3014
|
|
POST
|
I would love to be able to do this; the default stretched cards are awful looking. Can you post a screen shot of where you "created a class on the Gallery card called StopStretch"? I do not see where the box is to add a custom style tag. Thanks.
... View more
09-21-2021
10:55 AM
|
1
|
4
|
3975
|
|
IDEA
|
Yes, Yes. It is sometimes advantageous to manage documents in Sharepoint, rather than uploading to AGOL/Hub. Allowing external links in Gallery Cards would be a great help with this.
... View more
09-21-2021
10:51 AM
|
0
|
0
|
719
|
My kudoed posts
| Title | Kudos | Posted |
|---|---|---|
| 1 | 09-16-2020 03:40 PM | |
| 1 | 03-01-2019 01:46 PM | |
| 1 | 07-16-2019 08:13 AM | |
| 1 | 02-03-2022 02:20 PM | |
| 1 | 02-02-2022 07:07 AM |
Activity Feed
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 2 weeks ago
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 3 weeks ago
- Got a Kudo for Globally set "Allow assignment of unique numeric IDs for sharing web layers". 12-17-2025 12:12 PM
- Got a Kudo for Globally set "Allow assignment of unique numeric IDs for sharing web layers". 12-17-2025 12:12 PM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 12-11-2025 05:27 AM
- Got a Kudo for Re: Switch map on existing dashboard. 12-10-2025 03:33 AM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 12-09-2025 04:07 AM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 12-08-2025 10:54 AM
- Got a Kudo for Zoom to Selected Feature on Map Click. 11-11-2025 07:16 AM
- Got a Kudo for Allow adding fields to AGOL hosted layer with dependent JOIN . 11-05-2025 01:39 AM
- Got a Kudo for Allow adding fields to AGOL hosted layer with dependent JOIN . 11-05-2025 01:05 AM
- Got a Kudo for Allow adding fields to AGOL hosted layer with dependent JOIN . 11-04-2025 09:25 AM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 11-03-2025 06:44 PM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 11-02-2025 12:46 AM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 10-31-2025 04:33 AM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 10-24-2025 10:01 AM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 10-23-2025 12:14 PM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 10-23-2025 12:46 AM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 09-17-2025 12:11 PM
- Got a Kudo for Copy a page from one ExpBuilder to another (or import page). 09-12-2025 12:35 AM
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
01-13-2023
04:51 PM
|