How to format TQL results to omit (null) entries

Analytics and Teneo Query Language
1

I have a query that combines a number of sub queries in which each query produces a count that I want to show as the output of the main query.
Instead of showing the values side-by-side, it however creates a table result with a diagonal showing the counts, and the rest of the cells are filled with (null).
Is there some way to reduce this to a single line result with all the values?

image
image1609×697 201 KB

2

Hi Fred,

I think the way to combine them together is to create a groovy adorner

Chunlin

3

Thanks for the idea! Would we adorn the session header or the individual transactions. As with the latter, we just wind up with the same issue?

4

It depends on what you are counting. If you are counting on session id you need to adorn the session, otherwise you need to adorn transactions. Then use aggregator to aggregate the adorned sessions or transactions. However I´m not familiar with aggregators so i´m not quite sure if it will work or not.