Formatting values

[Matt_Hias]

Hi there,

I`m struggeling a bit with formatting values:

I created this thing, which basically is ok:

UID: http:url:66fe49bee5
label: Corona Mettmann
thingTypeUID: http:url
configuration:
  authMode: BASIC
  ignoreSSLErrors: false
  baseURL: https://services7.arcgis.com/mOBPykOjAyBO2ZKk/arcgis/rest/services/RKI_Landkreisdaten/FeatureServer/0/query?where=&objectIds=75&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&returnGeodetic=false&outFields=*&returnGeometry=false&returnCentroid=false&featureEncoding=esriDefault&multipatchOption=xyFootprint&maxAllowableOffset=&geometryPrecision=&outSR=4326&datumTransformation=&applyVCSProjection=false&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnQueryGeometry=false&returnDistinctValues=false&cacheHint=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&having=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false&returnExceededLimitFeatures=true&quantizationParameters=&sqlFormat=none&f=pjson&token=
  delay: 0
  stateMethod: GET
  refresh: 30
  commandMethod: GET
  contentType: application/json
  timeout: 3000
  bufferSize: 2048
channels:
  - id: cases7_per_100k
    channelTypeUID: http:number
    label: Inzident pro 100k
    description: null
    configuration:
      stateTransformation: JSONPATH:$.features[*].attributes.cases7_per_100k
  - id: cases
    channelTypeUID: http:number
    label: Fälle
    description: null
    configuration:
      stateTransformation: JSONPATH:$.features[*].attributes.cases
  - id: death
    channelTypeUID: http:number
    label: Tote
    description: null
    configuration:
      stateTransformation: JSONPATH:$.features[*].attributes.deaths
  - id: update
    channelTypeUID: http:string
    label: Aktualisiert
    description: null
    configuration:
      stateTransformation: JSONPATH:$.features[*].attributes.last_update
  - id: cases_per_100k
    channelTypeUID: http:number
    label: Fälle pro 100.000
    description: null
    configuration:
      stateTransformation: JSONPATH:$.features[*].attributes.cases_per_100k
  - id: EWZ
    channelTypeUID: http:number
    label: Anzahl Einwohner
    description: null
    configuration:
      stateTransformation: JSONPATH:$.features[*].attributes.EWZ
  - id: cases_per_population
    channelTypeUID: http:number
    label: Fälle auf alle Einwohner
    description: null
    configuration:
      stateTransformation: JSONPATH:$.features[*].attributes.cases_per_population

After putting everything into the model, it shows e.g. 15599:

But I would like to have it shown as 15.599 (incl. thousand separator).
Therefore I put the value

%1$,d

into the ‘Add Metadata - State Description - Pattern’ field of that item:

But then, it shows with an Err:

The same works actually for other items of the same thing:

[JustinG]

Fälle is a string item. Your transformation is for a number value (and works on Anzahl Einwohner which is a number item).

[Matt_Hias]

many thanks. Sometime life is so easy…