Home

Query help: Render array entries in barchart - timegenerated

%3CLINGO-SUB%20id%3D%22lingo-sub-1022855%22%20slang%3D%22en-US%22%3EQuery%20help%3A%20Render%20array%20entries%20in%20barchart%20-%20timegenerated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1022855%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20datatable%20consisting%20of%20three%20entries%20like%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%5Bfoo%2C%20bar%2C%20foo2%2C%20bar2%5D%0A%5Bfoo%2C%20bar%2C%20foo2%2C%20bar2%5D%0A%5Bboo%2C%20far%2C%20boo2%2C%20far2%2C%20boo3%5D%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20any%20chance%20to%20render%20this%20output%20in%20a%20barchart%20where%20the%20x-axis%20is%20%3CEM%3ETimeGenerated%26nbsp%3B%3C%2FEM%3Eand%20the%20y-axis%20is%20the%20stacked%20count%20of%20one%20entry%20of%20the%20datatable.%20Maybe%20the%20following%20is%20more%20expressive%20for%20you%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20708px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F158168iDCC3B2CD85E2C1F8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22diagram.png%22%20title%3D%22diagram.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%2C%20each%20color%20represents%20the%20occurrence%20of%20one%20element%20of%20one%20entry.%20In%20this%20case%20the%20second%20stack%20has%20more%20elements%20in%20its%20array%20as%20the%20first%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20is%20appreciated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESilvio%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1025376%22%20slang%3D%22en-US%22%3ERe%3A%20Query%20help%3A%20Render%20array%20entries%20in%20barchart%20-%20timegenerated%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1025376%22%20slang%3D%22en-US%22%3E%3CP%3EAnyone%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Dalesss
New Contributor

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 a barchart where the x-axis is TimeGenerated and the y-axis is the stacked count of one entry of the datatable. Maybe the following is more expressive for you:

 

diagram.png

 

Here, each color represents the occurrence of one element of one entry. In this case the second stack has more elements in its array as the first one.

 

Any help is appreciated!

 

Cheers,

 

Silvio

1 Reply