va/Assignment2_part2/export.ndjson

{"attributes":{"fieldAttrs":"{\"date\":{\"count\":2},\"aggregateRating\":{\"count\":3},\"averageCostForTwo\":{\"count\":3},\"city\":{\"count\":3},\"continent\":{\"count\":3},\"country\":{\"count\":3},\"location\":{\"count\":2},\"name\":{\"count\":3},\"ratingText\":{\"count\":3},\"votes\":{\"count\":3}}","fieldFormatMap":"{\"date\":{\"id\":\"date\",\"params\":{\"parsedUrl\":{\"origin\":\"http://localhost:5601\",\"pathname\":\"/app/maps/map\",\"basePath\":\"\"},\"pattern\":\"YYYY-MM-DD HH:mm:ss\",\"timezone\":\"Browser\"}},\"continent_scripted\":{\"id\":\"string\",\"params\":{\"parsedUrl\":{\"origin\":\"http://localhost:5601\",\"pathname\":\"/app/dev_tools\",\"basePath\":\"\"},\"pattern\":\"0,0.[000]\"}}}","fields":"[{\"count\":0,\"script\":\"doc['cityRaw.keyword'].value.substring(doc['cityRaw.keyword'].value.lastIndexOf(\\\"/\\\") + 1)\",\"lang\":\"painless\",\"name\":\"continent_scripted\",\"type\":\"string\",\"scripted\":true,\"searchable\":true,\"aggregatable\":true,\"readFromDocValues\":false,\"customLabel\":\"\"}]","name":"Assignment 2 - Part 2 - Claudio Maggioni","runtimeFieldMap":"{}","sourceFilters":"[]","timeFieldName":"date","title":"restaurants_extended_index*","typeMeta":"{}"},"coreMigrationVersion":"8.6.2","created_at":"2023-05-03T12:32:21.283Z","id":"705fe25a-022b-45b8-85cb-9979f4dd7169","migrationVersion":{"index-pattern":"8.0.0"},"references":[],"type":"index-pattern","updated_at":"2023-05-03T13:48:38.063Z","version":"WzY0NjYsOV0="}
{"attributes":{"columns":["name","city","country","continent","votes","aggregateRating","ratingText","averageCostForTwo"],"description":"","grid":{"columns":{"ratingText":{"width":132}}},"hideChart":false,"isTextBasedQuery":false,"kibanaSavedObjectMeta":{"searchSourceJSON":"{\"query\":{\"query\":\"\",\"language\":\"kuery\"},\"filter\":[],\"indexRefName\":\"kibanaSavedObjectMeta.searchSourceJSON.index\"}"},"sort":[],"timeRestore":false,"title":"Restaurants Saved Search","usesAdHocDataView":false},"coreMigrationVersion":"8.6.2","created_at":"2023-05-03T13:18:39.889Z","id":"04e56bd0-e9b5-11ed-a022-9f420f915bc7","migrationVersion":{"search":"8.0.0"},"references":[{"id":"705fe25a-022b-45b8-85cb-9979f4dd7169","name":"kibanaSavedObjectMeta.searchSourceJSON.index","type":"index-pattern"}],"type":"search","updated_at":"2023-05-03T13:18:39.889Z","version":"WzU3OTksOV0="}
{"attributes":{"description":"","kibanaSavedObjectMeta":{"searchSourceJSON":"{\"query\":{\"query\":\"\",\"language\":\"kuery\"},\"filter\":[]}"},"optionsJSON":"{\"useMargins\":true,\"syncColors\":false,\"syncCursor\":true,\"syncTooltips\":false,\"hidePanelTitles\":false}","panelsJSON":"[{\"version\":\"8.6.2\",\"type\":\"lens\",\"gridData\":{\"x\":0,\"y\":0,\"w\":12,\"h\":8,\"i\":\"d6f14e3b-6b5c-4cb1-a014-303afcdb140f\"},\"panelIndex\":\"d6f14e3b-6b5c-4cb1-a014-303afcdb140f\",\"embeddableConfig\":{\"attributes\":{\"title\":\"\",\"visualizationType\":\"lnsLegacyMetric\",\"type\":\"lens\",\"references\":[{\"type\":\"index-pattern\",\"id\":\"705fe25a-022b-45b8-85cb-9979f4dd7169\",\"name\":\"indexpattern-datasource-layer-e2c0bbee-e1f7-4433-8cc7-08f987759da9\"}],\"state\":{\"visualization\":{\"layerId\":\"e2c0bbee-e1f7-4433-8cc7-08f987759da9\",\"accessor\":\"5ee7d0a3-f243-40a0-a07c-264dceffd5f6\",\"layerType\":\"data\"},\"query\":{\"query\":\"\",\"language\":\"kuery\"},\"filters\":[],\"datasourceStates\":{\"formBased\":{\"layers\":{\"e2c0bbee-e1f7-4433-8cc7-08f987759da9\":{\"columns\":{\"5ee7d0a3-f243-40a0-a07c-264dceffd5f6\":{\"label\":\"Count of id\",\"dataType\":\"number\",\"operationType\":\"count\",\"isBucketed\":false,\"scale\":\"ratio\",\"sourceField\":\"id\",\"params\":{\"emptyAsNull\":true}}},\"columnOrder\":[\"5ee7d0a3-f243-40a0-a07c-264dceffd5f6\"],\"incompleteColumns\":{},\"sampling\":1}}},\"textBased\":{\"layers\":{}}},\"internalReferences\":[],\"adHocDataViews\":{}}},\"enhancements\":{},\"hidePanelTitles\":false},\"title\":\"Restaurant count\"},{\"version\":\"8.6.2\",\"type\":\"visualization\",\"gridData\":{\"x\":12,\"y\":0,\"w\":12,\"h\":8,\"i\":\"a902fc4a-180c-4578-86ac-1b40a7597c04\"},\"panelIndex\":\"a902fc4a-180c-4578-86ac-1b40a7597c04\",\"embeddableConfig\":{\"savedVis\":{\"id\":\"\",\"title\":\"\",\"description\":\"\",\"type\":\"input_control_vis\",\"params\":{\"controls\":[{\"id\":\"1683117395041\",\"fieldName\":\"aggregateRating\",\"parent\":\"\",\"label\":\"Rating\",\"type\":\"range\",\"options\":{\"decimalPlaces\":0,\"step\":1},\"indexPatternRefName\":\"control_a902fc4a-180c-4578-86ac-1b40a7597c04_0_index_pattern\"}],\"updateFiltersOnChange\":false,\"useTimeFilter\":false,\"pinFilters\":false},\"uiState\":{},\"data\":{\"aggs\":[],\"searchSource\":{\"query\":{\"query\":\"\",\"language\":\"kuery\"},\"filter\":[{\"meta\":{\"params\":{\"gte\":0,\"lte\":5},\"field\":\"aggregateRating\",\"key\":\"aggregateRating\",\"controlledBy\":\"1683117395041\",\"type\":\"range\",\"value\":{\"gte\":0,\"lte\":5},\"disabled\":false,\"negate\":false,\"alias\":null,\"indexRefName\":\"kibanaSavedObjectMeta.searchSourceJSON.filter[0].meta.index\"},\"query\":{\"range\":{\"aggregateRating\":{\"gte\":0,\"lte\":5}}},\"$state\":{\"store\":\"appState\"}}]}}},\"hidePanelTitles\":false,\"enhancements\":{}},\"title\":\"Aggregate Rating Filter\"},{\"version\":\"8.6.2\",\"type\":\"visualization\",\"gridData\":{\"x\":24,\"y\":0,\"w\":24,\"h\":14,\"i\":\"8cc6902f-b128-40ad-beeb-0a50fa209073\"},\"panelIndex\":\"8cc6902f-b128-40ad-beeb-0a50fa209073\",\"embeddableConfig\":{\"savedVis\":{\"id\":\"\",\"title\":\"\",\"description\":\"\",\"type\":\"histogram\",\"params\":{\"type\":\"histogram\",\"grid\":{\"categoryLines\":false},\"categoryAxes\":[{\"id\":\"CategoryAxis-1\",\"type\":\"category\",\"position\":\"bottom\",\"show\":true,\"scale\":{\"type\":\"linear\"},\"labels\":{\"show\":true,\"filter\":true,\"truncate\":100},\"title\":{},\"style\":{}}],\"valueAxes\":[{\"id\":\"ValueAxis-1\",\"name\":\"LeftAxis-1\",\"type\":\"value\",\"position\":\"left\",\"show\":true,\"scale\":{\"type\":\"linear\",\"mode\":\"normal\"},\"labels\":{\"show\":true,\"rotate\":0,\"filter\":true,\"truncate\":100},\"title\":{\"text\":\"Average Average Cost\"},\"style\":{}}],\"seriesParams\":[{\"show\":true,\"type\":\"histogram\",\"mode\":\"stacked\",\"data\":{\"label\":\"Average Average Cost\",\"id\":\"1\"},\"interpolate\":\"linear\",\"valueAxis\":\"ValueAxis-1\",\"drawLinesBetweenPoints\":true,\"lineWidth\":2,\"showCircles\":true,\"circlesRadius\":1}],\"radiusRatio\":0,\
{"attributes":{"@created":"2023-05-03T15:39:34.479Z","@timestamp":"2023-05-04T19:58:17.123Z","assets":{},"colors":["#37988d","#c19628","#b83c6f","#3f9939","#1785b0","#ca5f35","#45bdb0","#f2bc33","#e74b8b","#4fbf48","#1ea6dc","#fd7643","#72cec3","#f5cc5d","#ec77a8","#7acf74","#4cbce4","#fd986f","#a1ded7","#f8dd91","#f2a4c5","#a6dfa2","#86d2ed","#fdba9f","#000000","#444444","#777777","#BBBBBB","#FFFFFF","rgba(255,255,255,0)"],"css":".canvasPage {\n\n}","height":720,"isWriteable":true,"name":"Part 2 Canvas","page":0,"pages":[{"elements":[{"expression":"selectFilter\n| essql \n  query=\"SELECT cityRaw.keyword FROM restaurants_extended_index GROUP BY cityRaw.keyword\"\n| dropdownControl valueColumn=\"cityRaw.keyword\" filterColumn=\"cityRaw.keyword\"\n| render","filter":"","id":"element-368ea618-fc83-48bd-93ab-b8b71dc05ede","position":{"angle":0,"height":50,"left":20,"parent":null,"top":20,"width":500}},{"expression":"kibana\n| selectFilter\n| essql \n  query=\"select ratingText.keyword as rating, avg(averageCostForTwo) as cost from restaurants_extended_index group by ratingText.keyword, round(aggregateRating) order by round(aggregateRating)\"\n| pointseries x=\"rating\" y=\"cost\"\n| plot defaultStyle={seriesStyle bars=0.75}\n| render","filter":null,"id":"element-24ae51b8-2d31-41b4-bb21-4c0f9afb9ca6","position":{"angle":0,"height":300,"left":558,"parent":null,"top":29,"width":500}},{"expression":"kibana\n| selectFilter\n| essql query=\"SELECT * FROM \\\"restaurants_extended_index\\\"\"\n| mapColumn \"cheap\" exp={getCell \"averageCostForTwo\" | if {lte 300} then=1 else=0}\n| math \"sum(cheap) / count(cheap)\"\n| metric \"Cheap\" \n  metricFont={font size=48 family=\"'Open Sans', Helvetica, Arial, sans-serif\" color=\"#000000\" align=\"center\" lHeight=48} \n  labelFont={font size=14 family=\"'Open Sans', Helvetica, Arial, sans-serif\" color=\"#000000\" align=\"center\"} metricFormat=\"0,0.[000]%\"\n| render\n","filter":null,"id":"element-5f5b892c-5f9f-4276-bacc-7a892b3a10a7","position":{"angle":0,"height":81,"left":-1,"parent":null,"top":76,"width":271}},{"expression":"kibana\n| selectFilter\n| essql query=\"SELECT * FROM \\\"restaurants_extended_index\\\"\"\n| mapColumn \"cheap\" exp={getCell \"averageCostForTwo\" | if {lte 300} then=0 else=1}\n| math \"sum(cheap) / count(cheap)\"\n| metric \"Expensive\" \n  metricFont={font size=48 family=\"'Open Sans', Helvetica, Arial, sans-serif\" color=\"#000000\" align=\"center\" lHeight=48} \n  labelFont={font size=14 family=\"'Open Sans', Helvetica, Arial, sans-serif\" color=\"#000000\" align=\"center\"} metricFormat=\"0,0.[000]%\"\n| render\n","filter":null,"id":"element-0697e87d-c965-4325-a250-b23d4b275078","position":{"angle":0,"height":81,"left":-1,"parent":null,"top":166,"width":271}},{"expression":"kibana\n| selectFilter\n| essql \n  query=\"SELECT name, averageCostForTwo, ratingText FROM restaurants_extended_index\" count=10000\n| table perPage=5\n| render","filter":null,"id":"element-5f6b4314-cdd1-45a2-b5b1-6d072729781f","position":{"angle":0,"height":300,"left":33.5,"parent":null,"top":411,"width":1032.5}},{"expression":"kibana\n| selectFilter\n| essql \"SELECT sum(votes) as sumVotes FROM restaurants_extended_index\"\n| math \"sum(sumVotes)\"\n| metric \"Total votes\"\n| render","filter":null,"id":"element-e839b9ee-8550-4d22-8391-f9491f1ebd50","position":{"angle":0,"height":100,"left":261,"parent":null,"top":76,"width":200}},{"expression":"kibana\n| selectFilter\n| essql \"SELECT avg(averageCostForTwo) as avgCost FROM restaurants_extended_index\"\n| math \"sum(avgCost)\"\n| metric \"Average cost\"\n| render","filter":null,"id":"element-63b5cbf9-8f36-45ce-a369-11ab55fde5fb","position":{"angle":0,"height":100,"left":261,"parent":null,"top":157,"width":200}},{"expression":"kibana\n| selectFilter\n| essql \"SELECT avg(aggregateRating) as avgCost FROM restaurants_extended_index\"\n| math \"sum(avgCost)\"\n| metric \"Average rating\"\n| render","filter":null,"id":"element-f53b1935-8c8c-4526-b518-84bc08b616ee","position":{"angle":0,"height":100,"left":261,"parent":null,"top":247,
{"excludedObjects":[],"excludedObjectsCount":0,"exportedCount":4,"missingRefCount":0,"missingReferences":[]}