Latest Contributions by JanetBrewster1

Hello All, In Pro 3.4.2, I'm using the Divide tool to split a stream line into 9 equal parts. Pretty basic. The processing preview looks fine.... But the new reaches, sorted by ObjectID, are out of order. Rather than the first reach being the downstream-most, it's second from the upstream-most.  When I use the Split tool in ArcMap, it does this correctly (same data layer, same stream line). Any ideas why Pro would do this? Sounds like a bug to me.... Any thoughts would be greatly appreciated. Thanks! Janet ... View more

I would like to see more flexibility in determining a chart's value axis grid. Currently, there are no options on what value(s) will show up (other than the minimum). For this example, I get 0 and 100,000 -- that's it, and I can't adjust it. Yes, you can hover over the bars and get their amount, but visually this isn't ideal. The ability to set my own divisions, whether just tick marks on the x-axis or full grid lines, and whether labelled or not, would be very helpful (think of the similar flexibility we have in creating scale bars for maps).   Yes, I could create a Guide(s), but the placement of the label is funky and not consistent with the other pre-set labels. Thanks - Janet       ... View more

Hello All, I figured out some code to give me the results I need. However, I cannot get this new serial chart to adjust as I use various Selectors in my Dashboard. For example, I have a Location Selector where the user can choose one or more of the 20 locations and all the other charts and indicators in the Dashboard filter when a location(s) is chosen. However, this new chart does NOT change, regardless of the Actions I have set up (and actually, it won't save the Actions that I do select).  Do the Actions only work on charts that have not been created by Data Expressions?   // Purpose: Divide two fields from the same layer to use in Dashboard's Serial Chart //Access AGOL, using all attributes from one layer var portal = Portal('https://arcgis.com'); var fs = FeatureSetByPortalItem( portal, 'xyzx', 0, ['*'], false ); //Create empty dictionary var ratioDict = { 'fields': [ {'name': 'CPUE', 'type': 'esriFieldTypeDouble'}, {'name': 'LocationCode', 'type': 'esriFieldTypeDouble'}, //{'name': 'SHRC_Year', 'type': 'esriFieldTypeString'}, //{'name': 'Month', 'type': 'esriFieldTypeString'}, //{'name': 'SHRC_Month_Num', 'type': 'esriFieldTypeDouble'}, {'name': 'TotalSteelhead', 'type': 'esriFieldTypeDouble'}, {'name': 'TotalTrips', 'type': 'esriFieldTypeDouble'}, ], 'geometryType': '', 'features': [] }; var index = 0 //Loop through features in the featureset to populate dictionary for (var feature in fs) { ratioDict.features[index++] = { 'attributes': { 'LocationCode': feature ['LocationCode'], //'SHRC_Year': feature ['SHRC_Year'], //'Month': feature ['Month'], //'SHRC_Month_Num': feature ['SHRC_Month_Num'], 'TotalSteelhead': feature ['TotalSteelhead'], 'TotalTrips': feature ['TotalTrips'] } } }; var fsd = FeatureSet(ratioDict) //Get the sums grouped by a field var fs_sums = GroupBy(fsd, ['LocationCode'], [ {name: 'TS_sum', expression: 'TotalSteelhead', statistic: 'SUM'}, {name: 'TT_sum', expression: 'TotalTrips', statistic: 'SUM'}, ]) //Use GroupBy again, grouping by the same field but adding the needed ratio var fs_quotient = GroupBy(fs_sums, ['LocationCode'], [ {name: 'TS_sum', expression: 'TS_sum', statistic: 'SUM'}, {name: 'TT_sum', expression: 'TT_sum', statistic: 'SUM'}, {name: 'CPUE', expression: 'TS_sum / TT_sum', statistic: 'SUM'} ]); return fs_quotient     Yes, it's giving the correct results: featureSet: LocationCode TS_sum TT_sum CPUE ROW__ID 1 16025 29963 0.534826285752428 0 2 109246 59358 1.840459584217797 1 3 69862 72864 0.9587999560825647 2 4 620 1270 0.4881889763779528 3 5 17095 29364 0.5821754529355674 4 6 12965 22088 0.586970300615719 5 7 1664 3514 0.4735344336937962 6 8 12748 16645 0.7658756383298287 7 9 11461 38642 0.29659437917292064 8 10 1710 5211 0.3281519861830743 9 11 1273 3793 0.33561824413393093 10 12 84 659 0.1274658573596358 11 13 1023 2433 0.4204685573366215 12 15 39536 31782 1.2439745768044805 13 16 28672 26977 1.0628313007376655 14 17 11571 13044 0.8870745170193193 15 18 22342 45025 0.49621321488062187 16 19 4805 4671 1.028687647184757 17 20 2103 3423 0.6143733567046451 18   My Dashboard, with 3 Selectors that filter all the charts and indicators except for the one in lighter blue (the one created by my above data expression). Ideally, the new chart would adjust when any Selector is used, and I get why only the Location Selector might work (since that's what the data expression is aggregated on), but it doesn't work. And unfortunately, the Statistics available in the Data Options for the chart are limited and don't allow me to do the calculation that I want, hence the need to create the data expression. Am I trying to do something too complicated for the current iteration of Dashboards? I would love some feedback if anyone has thoughts. Thanks! Janet ... View more

When creating a chart or indicator or other type of feature in a Dashboard, I would love to see a Field Calculator (or something similar) to expand the kinds of calculations we can do, and eliminate the need to write 60 lines of code for a simple algebraic equation. I want to do more than what "Statistics" offers and I want to incorporate more than one field -- these expanded options need to result in fully interactive features regardless of the number of Selectors I include in the Dashboard. For example, with the current available options, I can't even create an average calculation from two fields. Thanks! ... View more

Hello All, I am creating a Dashboard from a complex data layer. The Dashboard includes one map, 11 charts (in 3 groups that the user can scroll through), 3 indicators, and 3 selectors. I've been able to link Actions for all the various pieces and am getting the results I want as the user makes different selections. However, as I add more complexity to the charts, my data layer keeps getting larger and larger -- it's just a ginormous flat file. And since Dashboards don't aggregate data like Excel Pivot Tables, I can't create summation charts with my giant flat file of a data layer. I've tried to use multiple data layers in the same Dashboard, but I'm not able to get all the charts, indicators, and map to change (via Actions) if they are created from different layers. Am I missing something? Is it possible to connect all the pieces of a Dashboard using multiple data layers, even if one layer is simply an aggregate of the other layer? I'm happy to provide more details, but I didn't want this to be too long. Many thanks for any insights! ... View more