Latest Contributions by LauraBecht

Hi, I have a table of accounts that have been joined to a table of taxing authorities in a many to one relationship. I need to summarize by the distinct account for a given taxing authority which has multiple city/mill codes. is this possible? Thanks, Laura Becht

Hi Lucas, I believe there is a pie symbol option that does what you are asking about. You need one categorical attribute and one numerical attribute for it to work, but the size is based on the numerical attribute and the color on the categorical one. I have attached a screenshot of an example. [cid:image001.png@01D80C42.B5EEA380] Regards, Laura Becht

Hi Lucas, I believe what you are talking about are cascading filters, which I have been told are hopefully going to be in the March update. To get around not having them for now, I am using a reference table to act as my lower level filter. They are wider than the predefined filters, but it is a useable work around for now. Regards, Laura Becht

‎12-02-2021

Hi, i have feature layers published to my portal by other members of my organization that i would like to be able to add to my workbook and filter using predefined filters, but i am unable to do so. I can filter layers i publish and host myself, but not ones published by others. Is there some kind of setting that is different, or is it because i am hosting it myself?

‎11-30-2021

For example, if i am filtering for country like your example, i would say "Country <> 'm'". Which would include blank values if they exist. if you want to exclude all blank/null values add "OR Country <> '' OR Country IS NOT NULL" I believe a dev told me you can use the null check. Please correct if i am wrong.

‎11-30-2021

Hello, When i am using a drop down filter and need to do the select all option, i use the advanced filter and say something like [group] <> '' or whatever statement selects all values for what you are filtering. Hope this helps!! Laura Becht

‎08-26-2021

Hi Michael, 1. You know, I don't think that is something you can do in insights currently, certainly is something to request though. You can do this in dashboards, have the list filter as you zoom a map, find what you are looking for, have a link from the dashboard to the insights page, set up a predefined filter or two... You can sync multiple maps so as you zoom one the other also zooms, but insights is driven by selection, so if you select in any card be it a table, chart, map, if cross filters are on it will zoom for those map cards. If you have a predefined filter set up and select in the filter it will zoom to whatever is selected in the filter, and table cards will show only what the filter has selected. 2. Turn off the cross filter for the map. It only zooms when cross filter is on. I hope you don't decide not to use insights. It is a very powerful analytical tool, I have been using it for almost two years now and still feel like I have so much to learn. Regards, Laura Becht

‎08-25-2021

Hi Shitij, That was an honest question as i haven't tried to schedule the model yet, it got put on hold for other unrelated reasons. I will let you know if any failure occurs without an error once i do start scheduling it. Laura

‎07-20-2021

This has always been something I didn't like about model builder. I have a model I need to schedule to run regularly. If the model fails is this reported anywhere? I am seriously considering running this model in a notebook instead just so I can see if there is an issue.

‎07-20-2021

Hi Ashley, I use large datasets on a regular basis in insights. I find that applying a predefined filter on the dataset helps with displaying the data in charts and maps. Do you need to display the entire dataset, or is there a way you can use a predefined filter. Regards, Laura Becht

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by LauraBecht

filter by distinct value

Re: Styling Items by Multiple Attributes

Re: Use Hierarchical Filters in Dashboards

filtering feature layers brought in from organization portal

Re: "Select all" from Dropdown Predefined filter?

Re: "Select all" from Dropdown Predefined filter?

Re: Filter by Map Zoom

Re: Messages in Model Builder

Re: Messages in Model Builder

Re: Working With Large Datasets in Insights