Forum Discussion
Query help: Render array entries in barchart - timegenerated
Hi all, I have a datatable consisting of three entries like this: [foo, bar, foo2, bar2]
[foo, bar, foo2, bar2]
[boo, far, boo2, far2, boo3] Is there any chance to render this output in...
UriBarash
Microsoft
MicrosoftHelloDalesss
Check out this:
let data=datatable(timestamp:datetime, elements:dynamic)[
'2020-02-02', dynamic(['foo', 'bar', 'foo2', 'bar2']),
'2020-02-03', dynamic(['foo', 'bar', 'foo2', 'bar2']),
'2020-02-04', dynamic(['boo', 'far', 'boo2', 'far2', 'boo3']),
'2020-02-05', dynamic(['boo', 'far', 'boo2', 'boo3'])];
data
| mv-expand elements
| summarize count() by timestamp, tostring(elements)
| render columnchart with(kind=stacked)