Compute a third metric in TimeLion from two existing metrics

[sanjaysubramanian]

Hi all

I am creating a TimeLion visualization in Kibana 7.7.0.
My Timelion is as follows

.es(index=my_index_1,metric=cardinality:conversation_id,q=*,timefield=ts).label('NEW CONVERSATIONS'),
.es(index=my_index_2,metric=cardinality:conversation_id,q=*,timefield=ts).label('ALL_CONVERSATIONS')

Now I need a third graph that diplays a third metric
Ration of new conversations to All Conversations
(NEW CONVERSATIONS) / (ALL_CONVERSATIONS)

How do I do that ?

Thanks

sanjay

[sanjaysubramanian]

I think I may have figured it out

I added a third time series

.es(index=my_index_1,metric=cardinality:conversation_id,q=,timefield=ts)
.multiply(10)
.divide(
.es(index=my_index_2,metric=cardinality:conversation_id,q=,timefield=ts)
).label('PERCENTAGE')