Condition totalized time as a statistic on Treemap

[Sivaji]

Is it possible to have a condition totalized time as a statistic on Treemap. Currently different types of statistics on signal is only available. Is there any workaround for this?

[Joe Reckamp]

Hi Sivaji,

You could do this in a couple different ways by turning the duration of the condition into a signal.

One method would be to use Signal from Condition to calculate the duration of each capsule in the condition and then performing a sum on that signal for the Treemap statistic:

Since you have to place the duration at a timestamp of each capsule, it means that if the "end" timestamp were selected as in the above example, the whole capsule would be counted even though half of the capsule may be off the edge of the time selected in the display. If this is an issue, I would recommend following the second approach. The second approach is to create a time counter signal using a Formula such as:

1.tosignal().within($condition)

You can then totalize that signal to get the total number of seconds:

If you want the value in a unit other than seconds, you can modify the example to use "sum" and a slightly different Formula that adds the units in. For example, in minutes:

[Sivaji]

Thanks Joe. Can I able to set the priority color based on the time counter value?

[Joe Reckamp]

You can only set the priority color based on conditions so you would need to create a condition off the signal. For example, you may do a Value Search to find when a capsule longer than a certain time length is found. In this case, you will first need to perform the totalized or summation using Signal from Condition and then you can do a Value Search on that signal.