I'm having a Data Table
type of graph, where I'm trying to display the number of count
metric as per a daily timestamp
.
Where I'm also having two filters
in order to sort out the exact count
.
This is how my table looks like.
What I need to know is, whether it's possible to calculate the Sum
of both the counts
per day within the same table?
In order to use the Sum
aggregation I need a field, where as I want to show the Sum
of the counts
. Is it possible do it via a json input
or a scripted field to calculate the sum of counts being displayed?
Any help could be appreciated.