I have a dashboard which displays information about password resets and I have a bar chart showing the top 20 accounts that have reset their passwords, code as follows:       index=keycloak "fields.environment"=production redirect_uri=* type=UPDATE_PASSWORD | rename customerReferenceAccountId as AccountID | top AccountID limit=20       This displays as a bar chat absolutely fine, however what I'm trying to achieve is to be able to click one of the bars in this chart, which will then display a table with AccountID, username, userId, redirect_uri, ipAddress, _time. Code as follows:       index=keycloak "fields.environment"=production customerReferenceAccountId=$AccountID$ type=UPDATE_PASSWORD | table $AccountID$, username, userId, redirect_uri, ipAddress, _time       In the first table I have set the "On Click" with a value of "Manage tokens on this dashboard" as follows: Set AccountID = $click.value$. However, when I click on one of the bars, the table below isn't displaying any information, I just get "No results found" but I know that there are results ... View more

So I'm trying to turn a single value number into a percentage but the code just returns a number still. Here's my code index="keycloak" "MFA" mfa="MFA code issued" OR (mfa="MFA challenge issued") | stats count AS Total count(eval(mfa="MFA code issued")) AS MFA_code_issued | eval Percentage=round(((MFA_code_issued/Total)*100),2) | table MFA_code_issued Percentage Just to give some context: MFA challenge issued = The number of challenges issued to customers to ask them whether they want to receive a OTP code via SMS or Email MFA code issued = The number of OTP codes that have actually been issued to customers So my colleagues have asked for the percentage of MFA codes issued ... View more