{"report":{"name":"demo/masterdetail","url":"/api/report/demo/masterdetail","hash":"e78431d3a23c","title":"Master and detail","description":"Pick rows, point at rows, click a row: other datasets, a chart and a window follow, with no request","layout":"report/masterdetail","manifest":"/api/report/demo/masterdetail?rt=manifest&v=e78431d3a23c","base":"/api/","data":"/api/report/demo/masterdetail?rt=data"},"path":"demo/masterdetail","hash":"e78431d3a23c","modules":[],"datasets":[{"alias":"params","path":"/core/params","load":"static","layout":"","urls":{"base":"/api/","data":"/api/report/demo/masterdetail?rt=data&ds=params","layout":""}},{"alias":"spend","path":"/demo/monthlySpend","load":"static","layout":"","urls":{"base":"/api/","data":"/api/report/demo/masterdetail?rt=data&ds=spend","layout":""}},{"alias":"cats","path":"/demo/spendByCategory","load":"static","layout":"","selected":"all","urls":{"base":"/api/","data":"/api/report/demo/masterdetail?rt=data&ds=cats","layout":""}},{"alias":"cats2","path":"/demo/spendByCategory","load":"static","layout":"","urls":{"base":"/api/","data":"/api/report/demo/masterdetail?rt=data&ds=cats2","layout":""}},{"alias":"cats3","path":"/demo/spendByCategory","load":"static","layout":"","urls":{"base":"/api/","data":"/api/report/demo/masterdetail?rt=data&ds=cats3","layout":""}},{"alias":"nav","path":"/demo/nav","load":"static","layout":"","chrome":true,"urls":{"base":"/api/","data":"/api/report/demo/masterdetail?rt=data&ds=nav","layout":""}},{"alias":"who","path":"/demo/who","load":"static","layout":"","chrome":true,"urls":{"base":"/api/","data":"/api/report/demo/masterdetail?rt=data&ds=who","layout":""}}],"clientDatasets":{"lines":{"from":"spend","filter":"category in (${cats.selected:category[]})","sort":"month"},"linesChart":{"from":"lines","select":{"x":"month","y":"amount","color":"category"}},"hovered":{"from":"spend","filter":"category = ${cats2.hover:category|!}","sort":"month","select":{"Month":"month","Amount":"amount"},"columns":{"Share of the category":{"calc":"Amount / sum(Amount)","type":"number","format":"percent:1"}}},"detail":{"from":"spend","filter":"category = ${cats3.selected:category|!}","sort":"month","columns":{"share":{"calc":"amount / sum(amount)","type":"number","format":"percent:1","displayName":"Share"},"best__top":{"calc":"max(amount)","type":"number"},"best":{"calc":"if(amount = best__top, 'best month', '')","displayName":""}}}}}