idea Operations Dashboard - Value Conversion for CHARTS in ArcGIS Dashboards Ideas

Operations Dashboard - Value Conversion for CHARTS

deleted-user-8TVt6oc0ewsX — Wed, 24 Oct 2018 17:42:13 GMT

The ability to apply a FACTOR (e.g. convert FEET to MILES) in an "Indicator" widget is VERY useful. I would like to see the same capability added to SERIAL Charts and PIE Charts. I want to sum length (feet) but report in MILES. I currently can only show feet in charts. Please add a "FACTOR" option to "Series" Labels.

Re: Operations Dashboard - Value Conversion for CHARTS

CodyHall — Mon, 25 Nov 2019 18:55:45 GMT

I agree, I'd like to see this ability added.

I'd like to convert gallons to liters before displaying on the chart. If I add access to the data structure I could make the change in the back-end, but sadly, I don't. I'm sure others are in the same position I am.

Re: Operations Dashboard - Value Conversion for CHARTS

JayJohnsonWashoeCounty — Thu, 30 Jul 2020 16:50:45 GMT

Yes, this would be handy. We have a COVID-19 dashboard and it would be useful to convert # of cases to # of cases per 100,000 on the fly, with out adding another field for this.

Re: Operations Dashboard - Value Conversion for CHARTS

OlesyaPowers — Tue, 29 Sep 2020 13:49:26 GMT

We're working on getting our infrastructure stats into live dashboards for both internal and public use. Mostly everything is reported in miles. This would help immensely to be able to convert this on the fly. Adding another column to the data, that isn't going to be auto updated by the software isn't going to help us a whole lot in this case.

Re: Operations Dashboard - Value Conversion for CHARTS - Status changed to: Already Offered

patrickb — Thu, 21 Oct 2021 19:26:55 GMT

The desired result (I believe) can be accomplished with data expressions.

Some examples here.

Re: Operations Dashboard - Value Conversion for CHARTS

CharlesHutchinson1 — Tue, 22 Mar 2022 21:01:47 GMT

Agree this basic functionality would be very useful. Data expressions do the job to an extent but having to write code just to convert units is quite a big ask for users unfamiliar with Arcade. It also introduces constraints in other areas, for example (as far as I can tell) charts based on expressions do not respond to spatial filters.

Re: Operations Dashboard - Value Conversion for CHARTS

HMarcks — Wed, 09 Nov 2022 17:41:09 GMT

This is marked as already available but it seems to only be available for the Gauge and Indicator NOT for Charts. If any one actually knowns how to use a conversion factor for a pie chart please share the method.

Sorry, I missed the above comment regarding using Arcade to convert values. It works but is a pain especially because the Globals are blank and I am sure a lot of people would not expect to have to do coding using the dashboard widgets.

Here is the code I used to get it done. I am very new to this so I made notes in terms that I understand as of now. Hopefully it helps others.

// GIS portal url from navigating to portal through browser var portal = Portal('https://www.youraddress.arcgis.com/'); var fs = FeatureSetByPortalItem( // Hosted feature layer id from navigating to it through browser web address portal, 'xxxxxxxxxxxxxxx', // layerID if sublayers are used also from web address xxxxxx, // Field names of attributes you want returned for use ['Shape__Length','assettype'], false ); // Miles of main converted from feet grouped by main type var fs_gp = GroupBy(fs, ['assettype'], [{name: 'Miles of Main', expression: 'Shape__Length*0.000189394', statistic: 'SUM' }]); return fs_gp

Data available in chart after codeHaving to re-label because I couldn't figure out how to get the domain names

Re: Operations Dashboard - Value Conversion for CHARTS

ChristineLazina11 — Thu, 21 Aug 2025 18:00:56 GMT

Just coming to agree that this functionality would be very welcome in other Dashboard widgets outside of gauges and indicators, and as far as I can tell this is not in fact available in these other use cases yet.