Charts - Treat double fields as integers
Allow the user to specify the way bins are labeled. This chart is showing integer data (ranging from 3-11 - 9 unique values and 9 bins), and while I found the option to only use one decimal place, my chart still has glaring issues. I have two sevens, and it's not immediately clear which bar the integers are each referring to. Before the two 7's, the number is before the bar; after the 7's, you must read the number to the right of the bar.
It would be better if the bin values could be labeled underneath, centered like the counts above.
For reference, this is what it shows by default.
Hi @wayfaringrob ,
Thanks for the question!
A histogram divides your data into bins, where each bin represents a range of values and the height of the bar represents the total number of values from your data that occur within that range. For instance, in the second screenshot you posted, there are 27 values in the "Index_Sum" field that fall between 6.6 and 7.4:
Because each bin in a histogram represents a range of values, it's important to show the lower and upper values for that bin.
If you are more interested in visualizing the number of occurrences for each integer value in the "Index_Sum" field, then you might want to use a bar chart instead.
Thanks,
Chris
For example, in working with crash data, my data source has all of these integer values stored as double; it's a little inconvenient to have to convert each and every field to integer just to take a glance at a reasonable chart. I suppose the idea, then, is to allow for more chart types from decimal fields.
@wayfaringrobThanks for the update and clarification!
As you've discovered, it’s currently not possible to create a bar chart using a Double field. We will keep an eye on this Pro Idea and potentially reevaluate this decision, but for now I’d like to show you one possible workaround.
If you are on Pro 3.1 or higher, you can use Arcade expressions to create the desired bar chart without needing to create and calculate new fields in your dataset. As an example, here I’d like to create a bar chart on the “year” field, which is type Double:
Since bar charts cannot be created on Double fields, the Bar Chart option is not shown when I right-click this field in the Data Engineering view. Instead, I’ll need to create a bar chart using the Create Chart menu option when you right-click the layer in the table of contents:
Now you should see a blank chart and the Chart Properties pane should open. Because the “year” field type is Double, it will not appear in the Category or Date dropdown for this bar chart. Instead, I’ll click the Arcade expression button to open the expression window:
In the expression window I’ll simply pass the “year” field into the Round Arcade function in order to round the values to the nearest integer:
When I click “OK”, I now see a bar chart that shows the number of records for each rounded integer value:
This approach obviously still requires some extra work but at least it saves you from needing to create and calculate new fields.
Take care,
Chris