In my KQL editor I have following query :
adt_history
| where SourceTimeStamp >= $__timeFrom and SourceTimeStamp <= $__timeTo
| where Id == 'VAT02' and Key == 'level'
| project SourceTimeStamp, Value=todouble(Value)
| order by SourceTimeStamp asc
This seems to work, but still I get an error line under $__timeFrom and $__timeTo.
“The name ‘$__timeFrom’ does not refer to any known column, table, variable or function.(KS142)”
Why is that?