I’ve got a query that renders a timechart like so. However, how can I also plot on the same graph where customDimensions.["Is Successful"] == "True"
?
customEvents
| extend Product = tostring(customDimensions.["Is Successful"])
| extend TransactionNumber = tostring(customDimensions.["Transaction Number"])
| extend StoreCode = tostring(customDimensions.["StoreCode"])
| extend TillNumber = tostring(customDimensions.["TillNumber"])
| extend TimeStamp = timestamp
| where name contains 'Transaction Posted' and customDimensions.['Transaction Number'] != ''
| where customDimensions.["Is Successful"] == "False"
| make-series Total=count() on TimeStamp from (startofday(now()) - 7days) to now() step 1d
| project-reorder TimeStamp, Total
| render timechart