In the code below itellisense redlines the new column with the warning that it doesn't exist, but the code runs fine and the column clearly exists. See screenshot below.
let T = materialize (
StormEvents
| where State in~ ("Alaska","Arkansas","Hawaii")
| summarize Events = count() by EventType, State
);
// state totals
T | summarize StateEvents = sum(Events) by State
// state/event totals
| join T on State
| project State, EventType, EventRatio = 1.0 * Events/StateEvents
// for some fun
| top-nested 3 of State by Dummy = max(1)
, top-nested 4 of EventType with others = "Other" by EventRatio = sum(EventRatio)
| where isnotempty(State)
| project-away Dummy
| render piechart with (xcolumn=EventType, ysplit=panels)
In the code below itellisense redlines the new column with the warning that it doesn't exist, but the code runs fine and the column clearly exists. See screenshot below.