Never mind, i figured it out 😄
in case anyone else ever runs into this sort of problem: this is the query to generate both number arrays for a HiddenchartFormatter:
system=cics | dedup tran | lookup cics_trans_id_lookup.csv cics_trans_id as tran OUTPUT cics_trans_area_name | dedup cics_trans_area_name | stats count as n | eval numbers=mvrange(0,n+2,1) | eval leftColumns=mvjoin(numbers, ",") | eval rightColumns="0,".tostring(n+2) | table leftColumns rightColumns
the bold printed part is the actual sequence generation, the italic part of the query is the base search, so to speak, where I'm only interested in n, the number of my applications, i.e. the number of categories that I have to stack.
... View more