Layers:

Layer: Monthly_Sales (0)


Name: Monthly_Sales

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -16623710.2540639
YMin: -7011688.78922395
XMax: 15796947.0751117
YMax: 10635593.2876537
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"visualVariables":[{"type":"sizeInfo","field":null,"valueExpression":"Round(Sum($feature.sales_apr,\r\n$feature.sales_aug,\r\n$feature.sales_dec,\r\n$feature.sales_feb,\r\n$feature.sales_jan,\r\n$feature.sales_jul,\r\n$feature.sales_jun,\r\n$feature.sales_mar,\r\n$feature.sales_may,\r\n$feature.sales_nov,\r\n$feature.sales_oct,\r\n$feature.sales_sept),2)","valueExpressionTitle":"Annual Sales Total","valueUnit":"unknown","minSize":6,"maxSize":22.5,"minDataValue":3587.13,"maxDataValue":9102.53}],"authoringInfo":{"visualVariables":[{"type":"sizeInfo","minSliderValue":3587.13,"maxSliderValue":9102.53}]},"type":"uniqueValue","field1":null,"valueExpression":"var totalsales = Sum($feature.sales_apr,\n $feature.sales_aug,\n $feature.sales_dec,\n $feature.sales_feb,\n $feature.sales_jan,\n $feature.sales_jul,\n $feature.sales_jun,\n $feature.sales_mar,\n $feature.sales_may,\n $feature.sales_nov,\n $feature.sales_oct,\n $feature.sales_sept)/12\n \nWhen(totalsales > 650, \"Exceeding Targets\", \n totalsales < 650 && totalsales >= 550,\"Meeting Targets\",\n \"Under performing\")\n","valueExpressionTitle":"Sales Performance","uniqueValueInfos":[{"value":"Under performing","label":"Under performing","symbol":{"color":[237,81,81,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Meeting Targets","label":"Meeting Targets","symbol":{"color":[20,158,206,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}},{"value":"Exceeding Targets","label":"Exceeding Targets","symbol":{"color":[167,198,54,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,255],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}}}]},"transparency":0}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: FID

Unique ID Field:

Name : FID

IsSystemMaintained : True


Global ID Field:

Type ID Field:

Fields:
• id (type: esriFieldTypeInteger, alias: id, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• first_name (type: esriFieldTypeString, alias: first_name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• last_name (type: esriFieldTypeString, alias: last_name, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• email (type: esriFieldTypeString, alias: email, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• gender (type: esriFieldTypeString, alias: gender, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• ip_address (type: esriFieldTypeString, alias: ip_address, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• sales_jan (type: esriFieldTypeDouble, alias: sales_jan, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_feb (type: esriFieldTypeDouble, alias: sales_feb, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_mar (type: esriFieldTypeDouble, alias: sales_mar, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_apr (type: esriFieldTypeDouble, alias: sales_apr, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_may (type: esriFieldTypeDouble, alias: sales_may, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_jun (type: esriFieldTypeDouble, alias: sales_jun, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_jul (type: esriFieldTypeDouble, alias: sales_jul, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_aug (type: esriFieldTypeDouble, alias: sales_aug, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_sept (type: esriFieldTypeDouble, alias: sales_sept, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_oct (type: esriFieldTypeDouble, alias: sales_oct, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_nov (type: esriFieldTypeDouble, alias: sales_nov, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• sales_dec (type: esriFieldTypeDouble, alias: sales_dec, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: latitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: longitude, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• FID (type: esriFieldTypeOID, alias: FID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/5/2017 12:39:14 PM

Schema Last Edit Date: 7/5/2017 12:39:14 PM

Data Last Edit Date: 7/5/2017 12:39:14 PM