Hi I have use case to display multiple aggrgated columns in visulisation. i am using data table as visulisation.
column 1 : sum of field 1 based on filteration in a given period
column 2: count of calls based on filteration in a given period
column 3 : sum of one field 3 based on filteration in a given period
column 4 : sum of one field 4 based on filteration in a given period
I have checked this option in tsvb. In My usecase, first avarage field and second average field the screenshot provided is having different filter conditions.
If eachfield is having filteroption, then this solve my usecase.
Can you please suggest any better way.
for column it is present, Can we use multiple columns in one bucket script ?
from screen shot provided by you, two fields are used in bucket script for the calculations. in my use case the two fields used in one column required different filteration and use calculation in bucketscript.
Hi Anji. I do not think the context of one column is available in another column. But perhaps you can create a copy of a column to use as a basis for a new column then build your expression on top of that.
For example in the screenshot below, I used the "Clone series" button on the Cache column to create a column called "Cache Minus Free" which I then modified to subtract the "Average of system.memory.free".
we have actual, used, free in catchminusfree column
actual is calculated as average of one field. here considering all the records in the given period.
but in myuse case we should not consider all the records for each field.
for actual one set of records based on filter,
for used one set of records based on filter,
for free one set of records based on filter,
this 3 different filters are not possible in one column.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.