Interactivity with multiple selections in grids about application-insights-workbooks HOT 6 CLOSED

let computers = dynamic([{Computers}]);
let workspaces = dynamic([{Workspaces}]);
// then in your query
something something | where Computer in (computers);

let values = dynamic([{SelectedRow}]);

print d = dynamic([{SelectedRow}])
| mv-expand d
| evaluate bag_unpack(d)
| project Computer, Workspace

let metric = dynamic({"counter":"% Committed Bytes In Use","object":"Memory"}) //dynamic({Counter});

let VMProcessWS = union withsource=WorkSpace VMProcess,
workspace("az1-dedicated-large-log").VMProcess,
workspace("az2-dedicated-large-log").VMProcess;

let PerfWS = union withsource=WorkSpace Perf,
workspace("az1-dedicated-large-log").Perf,
workspace("az2-dedicated-large-log").Perf;

let summaryPerComputer = totable(PerfWS      // hier die workspaces mergen
| where WorkSpace != "Perf"
| where TimeGenerated > ago (1d)  //{TimeRange}  
| where Computer contains ''  //{ComputerFilter}
| where ObjectName == metric.object and CounterName == metric.counter
| extend WS = substring(WorkSpace, indexof(WorkSpace, "az"), indexof(WorkSpace, "')")-indexof(WorkSpace, "az"))   
| where WS has_any(...) // {WorkSpaceFilter}
| summarize hint.shufflekey = Computer Average = avg(CounterValue), Max = max(CounterValue), Min = min(CounterValue), percentiles(CounterValue, 5, 10, 50, 80, 90, 95) by Computer, WS
| project Computer, WS, Average, Max, Min, P5th = percentile_CounterValue_5, P10th = percentile_CounterValue_10, P50th = percentile_CounterValue_50, P80th = percentile_CounterValue_80, P90th = percentile_CounterValue_90, P95th = percentile_CounterValue_95
| order by {TableTrend:label} {tableTrendOrder}, Computer);  

let AppsForeachWorker = VMProcessWS
| where TimeGenerated {TimeRange}
| where WorkSpace != "VMProcess"
| where UserName contains "..."
| extend WS = substring(WorkSpace, indexof(WorkSpace, "az"), indexof(WorkSpace, "')")-indexof(WorkSpace, "az"))
| summarize Apps=make_set(UserName) by TimeGenerated, Computer, WS
| summarize ["Last Data"]=arg_max(TimeGenerated, *) by Computer, WS;


summaryPerComputer 
| join kind=leftouter (AppsProWorker) on $left.Computer == $right.Computer and $left.WS == $right.WS
| project Computer, Workspace=WS, Average, P90th, Apps

let VMProcessWS = union withsource=WorkSpace VMProcess,
workspace("az1-dedicated-large-log").VMProcess,
workspace("az2-dedicated-large-log").VMProcess;