Hi I am trying to count how many times a player has done a run before they fought the boss. This is what I have currently and I want to check that this is calculating as intended so it will be anything before BossFoughtAmount has a value.
['events.all'] | where FullName_Name == "on_run_ended_by_winning" | where Timestamp > ago(10d) | extend RunsBeforeBoss = toint(EventData["_BossFoughtAmount"]) - 1 | where RunsBeforeBoss >= 0 | project format_datetime(Timestamp,'yyyy-MM-dd'),Entity_Id,FullName_Name,EventData, RunsBeforeBoss | summarize Players=dcount(Entity_Id), Wins=count() by Timestamp, RunsBeforeBoss | sort by Timestamp asc | render columnchart