Forum Discussion
Solved
Split visualisation in workbook
I'm working on a workbook/dashboard and I have this query which should show in a bar or area chart successful and failed logins by client app. SigninLogs | where TimeGenerated > ago(7d) | wher...
How about splitting the count() ?
SigninLogs | where TimeGenerated > ago(30d) | where isnotempty(ClientAppUsed) | extend Result= iff(ResultType ==0 ,"failure" ,"success" ) | summarize fail=countif(Result=="failure") , success=countif(Result=="success") by ClientAppUsed
You can do this another way, when you edit the Column and with Column renderer options. You could also colour code the results column
Thanks for the reply CliveWatson
That does work but it's not really what I'm after. Ideally I'd have a stacked chart so we could see the proportion of sign ins that were successful or failed versus the total.
It's very odd that the visualisation works in LA but not in the workbook.
How about splitting the count() ?
SigninLogs | where TimeGenerated > ago(30d) | where isnotempty(ClientAppUsed) | extend Result= iff(ResultType ==0 ,"failure" ,"success" ) | summarize fail=countif(Result=="failure") , success=countif(Result=="success") by ClientAppUsedThat's done it CliveWatson. Thanks!
