I would like to show two different results in a same chart. My idea is to search two different queries from two different sources but they are related to each other and i would like to show them (results as numbers) in the same chart
Is there any way to do that?
These are my two queries and first returns 7 as count and the second returns count as 35
I would like to show them in the same chart like
query1 = 7
_source = "wpb-auth-dev"
|parse "CompanyId=*," as CompanyId
|parse "DefaultMotoProvider=*:" as DefaultMotoProvider
| where !(DefaultMotoProvider matches "null")
| count_distinct(CompanyId) as Companies_Have_Set_Default_Provider
"(updatePaymentSubmission method) Transaction Succeed"
AND _source = "payments-dev"
| parse "invoiceCurrencyAmount=*," as PaidAmount
| parse "invoiceCurrency=*," as Currency
| parse "servicerName=*," as Provider
| parse "applicationId=*," as ProductId
| parse "paymentMethod=*," as PaymentMethod
| parse "companyId=*," as CompanyId
| where PaymentMethod="card-Moto"
| count_distinct(CompanyId) as Unique_CompanyIds_Accepted_MotoPayment
Please sign in to leave a comment.