Forum Discussion
Ullas Kumble
Microsoft
MicrosoftLog Analytics query with pivot
i am trying to write a pivot query
app("PaymentsAppInsights").customEvents
| where name == "PublishToTenantSuccess"
| where customDimensions.["TenantName"] == "UST"
| project SourceTransactionId =...
I was able to reproduce it too with my query. It happens to me only when using app().
The following produces the same error:
app('MY_APP').customEvents
| where ....
....
| evaluate pivot(name, sum(sum_dcount_user_Id))
While, this one works (when running in MY_APP):
customEvents | where .... .... | evaluate pivot(name, sum(sum_dcount_user_Id))
