Latest Contributions by JimMiller3

I have a dashboard with a serial chart (line), controlled by a selector action, to show state and county populations over several decades. Most rates of change are small, but not insignificant. If I set the value axis' minimum value to 0, the resulting line chart looks flat for many counties. Any growth or decrease in population can be difficult to see. But if I set the minimum value to "Automatic," the line chart begins at the lowest value in a series. That can make relatively small changes seem large. I would like to find a middle spot. What I would like to do is to set the Minimum Value as a percentage of the lowest value in the series. For example, 50%. So, if the lowest value in the series is 100,000, the value axis would begin at 50,000. I'd appreciate any guidance on if this is possible in the chart settings, through a data expression, or something else, and if there are any suggestions for a workaround.

‎08-05-2024

Thanks for the reply @ChristopherCounsell . My situation seems a little different. I'm fine with setting the default selection as the first category - a_tgf. I gave it a label of "Total Revenue." The problem comes when someone first opens the dashboard. The selector correctly shows "Total Revenue" as the default selection, but the serial chart incorrectly reflects values for all five categories in the selector (Total Revenue, Personal Income Tax, etc.) It's like the selector action initially isn't active. If I select a different category and then go back to "Total Revenue," that seems to jostle the selector action and the serial chart displays correctly. But if I refresh the page, the problem re-appears. Here's a screen grab of my selector configuration:

‎08-02-2024

I have a dashboard with a serial chart controlled by a category selector. I set the selector to default to the first category. But when the dashboard is first opened, the selector seemingly is inoperative. Instead, the chart reflects the sum of values for ALL categories. That yields very incorrect data (in this case, twice the correct amount.) If I use the selector to select another category and then go back to the default category, the selector properly filters the data displayed in the chart. Is there a solution to make a selector filter the data as soon as the dashboard opens?

‎05-15-2024

Thank you very much @JenniferAcunto for the reply and the blog post. Creating a faux title list element and grouping it with each of the elements for which I seek dynamic text in the title gets me to what I'd like to do. I follow your explanation about why people can’t add a dynamic field from their data into the title sections of their elements. In my use case, the dashboard category selector has the None option turned off. So the selector defaults to the first county_name value (Alameda County in this case.) All the data filters as such, with multiple records for each county_name. I understand that inserting something like {field/county_name[0]} for the title isn't an option, but that's how I think of it.

‎05-13-2024

I noticed that the latest Dashboard update increased the ability to insert dynamic text in the the title and description of an element. Does the enhanced functionality include field values, i.e. {field/field_name} ? I have indicator, pie chart and table elements that are controlled by a category selector of county names. I'd like the selected county name to be part of the title in each element so viewers would be clear what they're looking at. I don't see a way to do that. With the "Insert {}" button, I'm able to insert Language, Time Zone, and other dynamic text, but there are no field value options. Am I missing something, or is there a workaround? The indicator is a statistic value type, the pie chart has categories from grouped values, and the table is feature type. Thanks.

‎04-26-2024

I have a dashboard with a category selector that filters what symbols display on a map. But I can't find a way to make it so that the symbol size and legend classes in the map update to reflect the values of the category being filtered by the dashboard selector. Regardless of what's selected in the dashboard, the symbol size and legend never change. That hampers the user experience. For example: Working in Map Viewer, using 4 classes and Natural Breaks, and setting a filter on category 1, I get these classes. Doing the same with category 2, I get these classes. The classes update to reflect the new values being filtered in the map. And filtering on category 3 in the map also updates the classes. But no matter what category I filter on in the dashboard, the symbol size classes in the map remain unchanged. They seemingly reflect the lowest and highest values of the data among all the categories, and they never change to reflect the data being filtered on in the dashboard. Is there a step I need to take, or a workaround? I saw a similar post dealing with a selector updating a Heat Map style, but my map style is Counts and Amounts. Thanks.

‎03-21-2024

I have a view layer that is the source for a serial chart in a dashboard. A column that previously contained NaN values -- labeled 2022_23_chg -- now contains actual numbers. I want to add that column to my chart. I see the column in my view layer table view (screen grab below.) But that column is missing from the "Add Field" dropdown in the serial chart configure page. I've tried refreshing and double-checked the view layer settings. As an experiment, I created a new view layer and made a serial chart with that -- the 2022_23_chg field shows up in the configure dropdown. But I prefer to use my existing view layer and not have to re-wire several dashboard elements to a new view layer. And it seems like I shouldn't have to. Thank you for any suggestions.

‎12-11-2023

That is great news, @OwenGeo and @AbbyE_Esri . Thank you for your help on this.

‎10-18-2023

A follow-up question to the solution above @JenniferAcunto : If I want to also bold the values in the "Actual" and "Forecast" fields that correspond with the bolded values in the "Revenue Source" field, how do I structure the HTML and Arcade expression? I've tried several ways but I'm not getting the desired result This is my code: var bld = Concatenate('<strong>'+$datapoint.revenue_source+'</strong>') var rsrc=When($datapoint.revenue_source == 'Personal Income', bld, $datapoint.revenue_source == 'Corporation',$datapoint.revenue_source == 'Total',$datapoint.revenue_source == 'All Other Revenue' return { cells: { revenue_source: { displayText : rsrc, hoverText: $datapoint.revenue_source, textColor: '', backgroundColor: '', textAlign: 'left', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, Actual: { displayText: Text($datapoint["Actual"], '$#,###; -$#,###'), textColor: '', backgroundColor: '', textAlign: 'right', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, Forecast: { displayText: Text($datapoint["Forecast"], '$#,###; -$#,###'), textColor: '', backgroundColor: '', textAlign: 'right', iconName: '', iconAlign: '', iconColor: '', iconOutlineColor: '' }, This is my desired result. Thank you. Revenue Source Actual Forecast Personal Income 100 50 Withholding 25 25 Other Pmts 25 20 Refunds 50 5 Corporation 200 100 Estimated Pmts 100 50 Other Pmts 100 50 All Other Revenue 300 500 Total 600 650

‎10-16-2023

Good morning - I have a story map that combines a text narrative and one or more embedded dashboards per sidecar slide. As people scroll through the story map, the visible dashboards change. People like this experience a lot. In response to feedback, we want to add the functionality to download summarized .csv data from the dashboards within the story map. I've enabled summarized data download in the dashboard. When I click the download button in the story map, there's a message that the download has started with a progress bar (see screen grab below.) But I can't find a downloaded .csv file anywhere at the end. I came across this 2022 post and the provided solution from @OwenGeo. So my questions here are, notwithstanding the downloading in progress message I get, is it still the case no one can download data from an app within a story map? Or is a file actually being downloaded as the message in my story map says? If so, where is the .csv file going and how should we advise users? I read the advice in the 2022 post to link out to apps and let people download the data that way. For us, though, the best user experience would be to keep everyone within this Story Map app. Also we'd still have the problem of people seeing dashboard download buttons in the story map, clicking them, and wondering where the file went. Thanks.

‎09-21-2023

My dashboard includes a100% stacked bar chart for revenue categories. The hover text currently displays the dollar amount of each category bar. The client wants the hover text to instead display each category's percentage of total revenue. It appears that requires a data expression. So, consulting this post, I've set out to create a data expression that defines a variable of total revenue by month and type (actual or forecast), and uses that to generate a percentage for each revenue category. I'm able to get total revenue by month and type with the following: var tot_val= GroupBy( fs, ['month_year_x','type'], [{ name:'total_rev', expression:'value', statistic: 'SUM'}]); But I get an error message when I try to use the above variable in a subsequent section of code to calculate a revenue source's percentage of the total. return GroupBy( fs, ['rev_category','month_year_x','type'], [{ name:'value_pct', expression: 'value /tot_val', statistic: 'SUM' } ]); The resulting serial chart would be categorized on the month_year field and split by the rev_category field. It also would include a filter so that the chart only displays "actual" numbers. Thanks.

‎09-09-2023

I agree. It is odd that one can configure the category axis labels in a serial chart, but not the actual hover-text. Also odd that the axis labels don't just carry through to the hover-text. The result is a mismatch that could confuse viewers. I've tried several workarounds, with no success.

‎09-08-2023

I've seen a few posts about date values in dashboard serial charts. They mostly seem related to date data being interpreted as strings. This dashboard idea post is similar to my issue. My attribute data is coming in just fine. I have the X (category) axis showing month and year. The problem is that the text hover on the serial chart shows month, year and day. I don't want the day number to show - it is a placeholder value. I want the text-hover to be just month and year. This is what I currently have: Below is what I want. Even better if month could be represented as the name, i.e. Nov, shown in the X axis. Update: As a possible workaround, I generated a date value that is the last day of a respective month. The goal: to try to convey to the viewer that the displayed value is through the end of that month. But the dashboard serial chart hover-text still shows the first day of the month. Could a data expression get the desired result and, if so, how would one craft it? Or is there a simpler solution? Thank you.

‎08-25-2023

Thanks - that worked perfectly.

‎08-24-2023

I've been working from both of these helpful posts about using Arcade to format values and cells in dashboard tables. I've been able to do some things, such as formatting numbers and percentages. But I haven't been able to figure out how to bold specific values in a column and, for other values, change textAlign from left to center. I can use displayText to make all values bold, or textAlign to make all values center aligned. My goal, though, is to make those changes for just certain values in the column. Below is my desired output for the "Revenue Source" field. Thank you for any suggestions. Revenue Source Personal Income Withholding Other Pmts Refunds Corporation Estimated Pmts Other Pmts All Other Revenue Insurance Tobacco Other

Online Status	Offline
Date Last Visited	Friday

My Ideas

Latest Contributions by JimMiller3

Customizing serial chart value axis minimum values

Re: Category Selector doesn't filter when dashboard opens

Category Selector doesn't filter when dashboard opens

Re: Including field value in dashboard element title

Including field value in dashboard element title

Getting map classifications to reflect dashboard selector filters

View layer field missing from serial chart configure dropdown

Re: Downloading data from embedded dashboard app within story map

Re: Using Arcade expressions to format specific values in Dashboard table field

Downloading data from embedded dashboard app within story map

Creating a data expression to calculate categories' percentage shares of total amount

Re: Configure dashboard hover-text

Formatting date hover text to show only month and year in dashboard serial chart

Re: Using Arcade expressions to format specific values in Dashboard table field

Using Arcade expressions to format specific values in Dashboard table field

Category Selector doesn't filter when dashboard o...

View layer field missing from serial chart configu...

Downloading data from embedded dashboard app withi...

Creating a data expression to calculate categories...

Presenting categories' percentage of total in Stac...