MSP Sales

Error rendering component: singleValue
class org.openjdk.nashorn.internal.runtime.ECMAException - SyntaxError: Invalid JSON: :1:353 Expected json literal but found } {"stored_fields":["recordId","amount","dateEntered","periodFrom","rewardsIssuedDate","Tags","salesTeamId"],"query":{"bool":{"must":[{"type":{"value":"dataSeriesRecord"}},{"bool":{"must":[{"range":{"periodFrom":{"gte":"2026-04-10T05:00:00Z","lte":"2026-04-18T04:59:59.000000999Z"}}},{"terms":{"salesTeamOrgTypeIds":["130639087"]}},{"terms":{"parentOrgs":}}]}}]}},"from":0,"size":10,"aggs":{"total-records":{"avg":{"field":"amount"}},"LUx7E9JCU_7HBQI4B3Blo":{"terms":{"field":"productSku","shard_size":100000,"size":20,"order":{"Lzfm86O_YVAPkbcxROwfU":"desc"}},"aggs":{"Lzfm86O_YVAPkbcxROwfU":{"sum":{"field":"amount"}}}},"KjLEXqD7uNQFm1CYrrjsA":{"terms":{"field":"salesTeamId","shard_size":100000,"size":20},"aggs":{"KwDCFecFk7x6woNoY99pX":{"sum":{"field":"amount"}}}},"Qr31aJqdspjdP0K-l3xxX":{"sum":{"field":"amount"}},"defaultDateHistogram_0":{"date_histogram":{"field":"periodFrom","interval":"1d","extended_bounds":{"min":"2026-04-10T05:00:00Z","max":"2026-04-18T04:59:59.000000999Z"}}}}} ^
Error rendering component: singleValue
class org.openjdk.nashorn.internal.runtime.ECMAException - SyntaxError: Invalid JSON: :1:353 Expected json literal but found } {"stored_fields":["recordId","amount","dateEntered","periodFrom","rewardsIssuedDate","Tags","salesTeamId"],"query":{"bool":{"must":[{"type":{"value":"dataSeriesRecord"}},{"bool":{"must":[{"range":{"periodFrom":{"gte":"2026-04-10T05:00:00Z","lte":"2026-04-18T04:59:59.000000999Z"}}},{"terms":{"salesTeamOrgTypeIds":["130639087"]}},{"terms":{"parentOrgs":}}]}}]}},"from":0,"size":10,"aggs":{"total-records":{"avg":{"field":"amount"}},"LUx7E9JCU_7HBQI4B3Blo":{"terms":{"field":"productSku","shard_size":100000,"size":20,"order":{"Lzfm86O_YVAPkbcxROwfU":"desc"}},"aggs":{"Lzfm86O_YVAPkbcxROwfU":{"sum":{"field":"amount"}}}},"KjLEXqD7uNQFm1CYrrjsA":{"terms":{"field":"salesTeamId","shard_size":100000,"size":20},"aggs":{"KwDCFecFk7x6woNoY99pX":{"sum":{"field":"amount"}}}},"Qr31aJqdspjdP0K-l3xxX":{"sum":{"field":"amount"}},"defaultDateHistogram_0":{"date_histogram":{"field":"periodFrom","interval":"1d","extended_bounds":{"min":"2026-04-10T05:00:00Z","max":"2026-04-18T04:59:59.000000999Z"}}}}} ^

Top MSPs by Sale Amount

Error rendering component: barsChart
class org.openjdk.nashorn.internal.runtime.ECMAException - SyntaxError: Invalid JSON: :1:353 Expected json literal but found } {"stored_fields":["recordId","amount","dateEntered","periodFrom","rewardsIssuedDate","Tags","salesTeamId"],"query":{"bool":{"must":[{"type":{"value":"dataSeriesRecord"}},{"bool":{"must":[{"range":{"periodFrom":{"gte":"2026-04-10T05:00:00Z","lte":"2026-04-18T04:59:59.000000999Z"}}},{"terms":{"salesTeamOrgTypeIds":["130639087"]}},{"terms":{"parentOrgs":}}]}}]}},"from":0,"size":10,"aggs":{"total-records":{"avg":{"field":"amount"}},"LUx7E9JCU_7HBQI4B3Blo":{"terms":{"field":"productSku","shard_size":100000,"size":20,"order":{"Lzfm86O_YVAPkbcxROwfU":"desc"}},"aggs":{"Lzfm86O_YVAPkbcxROwfU":{"sum":{"field":"amount"}}}},"KjLEXqD7uNQFm1CYrrjsA":{"terms":{"field":"salesTeamId","shard_size":100000,"size":20},"aggs":{"KwDCFecFk7x6woNoY99pX":{"sum":{"field":"amount"}}}},"Qr31aJqdspjdP0K-l3xxX":{"sum":{"field":"amount"}},"defaultDateHistogram_0":{"date_histogram":{"field":"periodFrom","interval":"1d","extended_bounds":{"min":"2026-04-10T05:00:00Z","max":"2026-04-18T04:59:59.000000999Z"}}}}} ^

Top MSPs by Number of Sales

Error rendering component: barsChart
class org.openjdk.nashorn.internal.runtime.ECMAException - SyntaxError: Invalid JSON: :1:353 Expected json literal but found } {"stored_fields":["recordId","amount","dateEntered","periodFrom","rewardsIssuedDate","Tags","salesTeamId"],"query":{"bool":{"must":[{"type":{"value":"dataSeriesRecord"}},{"bool":{"must":[{"range":{"periodFrom":{"gte":"2026-04-10T05:00:00Z","lte":"2026-04-18T04:59:59.000000999Z"}}},{"terms":{"salesTeamOrgTypeIds":["130639087"]}},{"terms":{"parentOrgs":}}]}}]}},"from":0,"size":10,"aggs":{"total-records":{"avg":{"field":"amount"}},"LUx7E9JCU_7HBQI4B3Blo":{"terms":{"field":"productSku","shard_size":100000,"size":20,"order":{"Lzfm86O_YVAPkbcxROwfU":"desc"}},"aggs":{"Lzfm86O_YVAPkbcxROwfU":{"sum":{"field":"amount"}}}},"KjLEXqD7uNQFm1CYrrjsA":{"terms":{"field":"salesTeamId","shard_size":100000,"size":20},"aggs":{"KwDCFecFk7x6woNoY99pX":{"sum":{"field":"amount"}}}},"Qr31aJqdspjdP0K-l3xxX":{"sum":{"field":"amount"}},"defaultDateHistogram_0":{"date_histogram":{"field":"periodFrom","interval":"1d","extended_bounds":{"min":"2026-04-10T05:00:00Z","max":"2026-04-18T04:59:59.000000999Z"}}}}} ^

Top SKUs by Sales Amount

Error rendering component: pieChart
class org.openjdk.nashorn.internal.runtime.ECMAException - SyntaxError: Invalid JSON: :1:353 Expected json literal but found } {"stored_fields":["recordId","amount","dateEntered","periodFrom","rewardsIssuedDate","Tags","salesTeamId"],"query":{"bool":{"must":[{"type":{"value":"dataSeriesRecord"}},{"bool":{"must":[{"range":{"periodFrom":{"gte":"2026-04-10T05:00:00Z","lte":"2026-04-18T04:59:59.000000999Z"}}},{"terms":{"salesTeamOrgTypeIds":["130639087"]}},{"terms":{"parentOrgs":}}]}}]}},"from":0,"size":10,"aggs":{"total-records":{"avg":{"field":"amount"}},"LUx7E9JCU_7HBQI4B3Blo":{"terms":{"field":"productSku","shard_size":100000,"size":20,"order":{"Lzfm86O_YVAPkbcxROwfU":"desc"}},"aggs":{"Lzfm86O_YVAPkbcxROwfU":{"sum":{"field":"amount"}}}},"KjLEXqD7uNQFm1CYrrjsA":{"terms":{"field":"salesTeamId","shard_size":100000,"size":20},"aggs":{"KwDCFecFk7x6woNoY99pX":{"sum":{"field":"amount"}}}},"Qr31aJqdspjdP0K-l3xxX":{"sum":{"field":"amount"}},"defaultDateHistogram_0":{"date_histogram":{"field":"periodFrom","interval":"1d","extended_bounds":{"min":"2026-04-10T05:00:00Z","max":"2026-04-18T04:59:59.000000999Z"}}}}} ^

Top SKUs by Number of Sales

Error rendering component: pieChart
class org.openjdk.nashorn.internal.runtime.ECMAException - SyntaxError: Invalid JSON: :1:353 Expected json literal but found } {"stored_fields":["recordId","amount","dateEntered","periodFrom","rewardsIssuedDate","Tags","salesTeamId"],"query":{"bool":{"must":[{"type":{"value":"dataSeriesRecord"}},{"bool":{"must":[{"range":{"periodFrom":{"gte":"2026-04-10T05:00:00Z","lte":"2026-04-18T04:59:59.000000999Z"}}},{"terms":{"salesTeamOrgTypeIds":["130639087"]}},{"terms":{"parentOrgs":}}]}}]}},"from":0,"size":10,"aggs":{"total-records":{"avg":{"field":"amount"}},"LUx7E9JCU_7HBQI4B3Blo":{"terms":{"field":"productSku","shard_size":100000,"size":20,"order":{"Lzfm86O_YVAPkbcxROwfU":"desc"}},"aggs":{"Lzfm86O_YVAPkbcxROwfU":{"sum":{"field":"amount"}}}},"KjLEXqD7uNQFm1CYrrjsA":{"terms":{"field":"salesTeamId","shard_size":100000,"size":20},"aggs":{"KwDCFecFk7x6woNoY99pX":{"sum":{"field":"amount"}}}},"Qr31aJqdspjdP0K-l3xxX":{"sum":{"field":"amount"}},"defaultDateHistogram_0":{"date_histogram":{"field":"periodFrom","interval":"1d","extended_bounds":{"min":"2026-04-10T05:00:00Z","max":"2026-04-18T04:59:59.000000999Z"}}}}} ^

Sales by Period (vs. previous period)

Sales Records

Blank
Sales Details
Organisation ID Title Address line 1 Address line 2 State City Country Postcode
westwood Westwood 20 Hatha Drive CA Collinsville US 12334
apex-dealership-partnerportal Apex California 2010 South Bundy Avenue Los Angeles CA US 90025.0
winters-dealer Winters Direct 2001 Hitha Avenue MO Collinsville US 63111
testorg-1 testorg-1