Space-Time Cube: Number Format/ Rounding

123
3
07-23-2021 04:05 PM
Labels (1)
S9820
by
New Contributor

Hi all,

I'm trying to create a space-time cube with the aggregation shape type set to "defined location" (census tract boundaries). To do this, a unique Location ID is required which I have, but not in the correct format (required format: String, Numeric). I've tried creating a new field and changing the setting to the proper numeric format but I'm still unable to preserve the location ID values and preventing rounding.

Ex. location ID such as '5350007.01' either rounds to 5350007.00 or 5350007

How can I preserve the original formatting?

0 Kudos
3 Replies
DanPatterson
MVP Esteemed Contributor

if required format is String or Numeric, what is wrong with your string value that you have shown?


... sort of retired...
0 Kudos
S9820
by
New Contributor

the space-time cube only recognizes string values for the 'Location ID'. the decimals get lost when stored in a long/short format and therefore lose their uniqueness. However, when I store the data as a double (numeric) the tool doesn't recognize the field. 

0 Kudos
DanPatterson
MVP Esteemed Contributor

hence use string format since text or integer is supported and a string representation of a decimal value will be unique


... sort of retired...
0 Kudos