Latest Contributions by LisaDygert

‎10-29-2021

Hello, I have created a Survey123 app that meets the needs of the requestors except for one issue. They would like to have the different select_one option groups relevant settings (and the associated data with those) to export as different tabs in an excel spreadsheet or as different csv files. I know that can be accomplished in setting up repeats as it creates related tables, but is there another way to accomplish the same task? There is no need for repeats in any of the options chosen. There will always be just one. As an example, they need to choose whether they want to enter information in for: Level 1 Assessment, Level 2 Assessment, Seasonal Start-Up, GWR Violation, Treatment Visit, or Annual Site Visit. Once they choose which option they want, a series of questions appear and there will not be a case where more than one Level 1 Assessment will need to be entered for the same feature. I know that I could also split them up into different forms, but that isn't ideal since the first few questions are the same for each feature. Thanks in advance for any suggestions. Lisa D.

‎10-21-2021

It would be great if we could hide sensitive data in Power BI like addresses and coordinates. Due to concern of potential homeland security risks that could affect public health, there is a need to not allow users to have access to the exact location for public water systems. We want them to appear on the map, but not allow users to know exactly where that is. It would be great to allow certain columns to be not accessible to users even if it is in the map and/or tables.

‎10-19-2021

Hello, I am using the ArcGIS for Power BI visual in Power BI. I have a table with coordinates that I am using for the location data, but I don't want those coordinates to be available in the pop-up window when you select a location or the data exports. Is there a way to hide that sensitive information? I have seen other ways to hide data in Power BI, but nothing that will work well for coordinates or addresses from what I can see. Is there a way to hide this sensitive data? Thanks in advance for any assistance with this. Lisa D.

‎10-19-2021

Hello, I am using the ArcGIS for Power BI visual in Power BI. Is there a way to not show the location data in the pop-up windows or data exports to avoid sharing sensitive information? I have seen ways to hide other types of data in Power BI, but there doesn't seem to be anything specifically for hiding addresses or coordinates if we do not want those available once published. Thanks in advance for any assistance with this. Lisa D.

‎07-09-2021

Hi Julie, Have you tried the solution offered here? //www.gobook3.com/t5/arcgis-survey123-questions/survey-123-decimal-places/m-p/771381 Lisa D.

‎07-08-2021

Hi Peg, You can enter in if statements in the Required fields so that at least one of them is completed. You can ask questions like 'Do you know the exact date for the field sample?' If they answer yes, you can set up a relevant statement to include the option for the dd/mm/yyyy. If they say no, then you can ask if they know the month and year....so forth. So, you are most likely going to get the exact date if known, and if not at least the month and year, so forth. The options will only appear as they indicate yes or no to what information they do know and then you can make the last option the required field, so that they have to at least enter in the year.

‎06-29-2021

Hello, I am using the ArcGIS Power BI geocoding tool to create points from a list of addresses and it works great. Is it possible to export the spatial information? I know you can export to a csv file, but is there an option to create an export with coordinates or as a point dataset? Thanks in advance for any assistance. Lisa D.

‎06-29-2021

Hello, I want to create a map using ArcGIS for Power BI that would show more than one layer in the same map visual. Is that possible? I have water sample results data. I am using the addresses for the point locations. Ideally, I would like to be able to create a map that shows all result values that are not detected (ND) as a specific color and size circle. All results ranging from 0-5 as a different specific color and size circle. All results ranging from 5-10 as a different specific color and size circle, and all results greater than 10 as a specific color and size circle. If I try to load it all as one table (layer), I don't seem to get the options to be able to specify manual breaks in the values for the results field for size. I can choose the colors I want if I create a new field that creates classes for each of the result value groups I listed earlier, but the size classes, I cannot seem to be able set manually. If I try to add the data in as separate layers (tables) with filters set for each so to create the color groups that way, it symbolizes all of the layers the same. If I change the color and/or size for one of them, it changes the color and size for all of them as the same. Is there a way to be able to display data in this fashion to be able to display the data as I need? Thanks in advance for any assistance. Lisa D

‎06-03-2021

I am referring to the hosted feature layers that get creates from Survey123 forms which are not stored in portal. I don't believe the document you sent includes that situation, correct?

‎06-03-2021

Since Esri does not currently provide a data back-up option for hosted feature layers, there should be a way to easily export a hosted feature layer as a feature layer on a local ArcGIS web server. That way, the data can be backed-up in a sense. With this....there should be ways to maintain the original globalid values so that relates are not lost.

Online Status	Offline
Date Last Visited	‎10-29-202103:26 PM

My Ideas

Latest Contributions by LisaDygert

Export xls tabs or csv files

Hide Sensitive Data in Power BI

Hide sensitive data in ArcGIS for Power BI

Hide sensitive data in ArcGIS for Power BI

Re: Truncate to specific number of decimal places?

Re: Dates and Time in Survey123

Export Spatial Data

Multiple layers in Power BI

Re: Hosted Feature Layer copy to ArcGIS Server as a back-up data option

复制ArcGIS的服务器托管功能层a back-up data option

Autocomplete search with external csv and calculat...

复制ArcGIS的服务器托管功能层a ba...

Fields only accessible to certain users?

SQL Trigger in Versioned SDE

Python issue