Can't create dashboard

%3CLINGO-SUB%20id%3D%22lingo-sub-150496%22%20slang%3D%22en-US%22%3ECan't%20create%20dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-150496%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3EI'm%20trying%20to%20create%20a%20line%20dashboard%20with%20the%20following%20query%3A%3C%2FP%3E%0A%3CP%3EPerf%20%3CBR%20%2F%3E%20%7C%20%3CBR%20%2F%3Ewhere%20CounterName%20%3D%3D%20%22%25%20Committed%20Bytes%20In%20Use%22%20and%20TimeGenerated%20%26gt%3B%20ago(2h)%20%3CBR%20%2F%3E%7C%3CBR%20%2F%3E%20summarize%20average_committed_bytes_percent%20%3D%20avg(CounterValue)%20by%20Computer%20%3CBR%20%2F%3E%20%7C%3CBR%20%2F%3E%20where%20average_committed_bytes_percent%20%26lt%3B%2050%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eand%20when%20I%20click%20apply%20i%20get%20the%20error%20(400)%20Failed%20to%20resolve%20entity%20TimeGenerated.%3C%2FP%3E%0A%3CP%3EThis%20happens%20even%20after%20I%20remove%20the%20%22and%20TimeGenerated%20%26gt%3B%20ago(2h)%22%20condition.%3C%2FP%3E%0A%3CP%3EI%20don't%20get%20what's%20wrong.%3C%2FP%3E%0A%3CP%3ECan%20you%20help%20me%3F%3C%2FP%3E%0A%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-150496%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Log%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EQuery%20Language%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EView%20Designer%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-187013%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-187013%22%20slang%3D%22en-US%22%3EThis%20saved%20me%20from%20a%20headache.%20the%20400%20error%20makes%20no%20sense.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-150504%22%20slang%3D%22en-US%22%3ERe%3A%20Can't%20create%20dashboard%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-150504%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20the%20issue%2C%20which%20is%20completely%20different%20from%20the%20error%20message.%3C%2FP%3E%0A%3CP%3EWhile%20the%20error%20states%20there's%20a%20problem%20with%20TimeGenerated%2C%20the%20issue%20is%20that%20the%20summarize%20variable%20name%20%22average_committed_bytes_percent%22%20is%20too%20long.%20When%20I%20changed%20to%20something%20much%20shorter%20like%20%22avgram%22%20it%20worked.%3C%2FP%3E%0A%3CP%3EThe%20error%20code%20needs%20to%20be%20changed.%20I%20wasted%20several%20hours%20trying%20to%20find%20out%20what's%20going%20on.%20Is%20there%20any%20way%20to%20send%20this%20feedback%20so%20this%20doesn't%20happen%20to%20other%20users%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi,

I'm trying to create a line dashboard with the following query:

Perf
|
where CounterName == "% Committed Bytes In Use" and TimeGenerated > ago(2h)
|
summarize average_committed_bytes_percent = avg(CounterValue) by Computer
|
where average_committed_bytes_percent < 50

 

 

 

 

and when I click apply i get the error (400) Failed to resolve entity TimeGenerated.

This happens even after I remove the "and TimeGenerated > ago(2h)" condition.

I don't get what's wrong.

Can you help me?

Thanks in advance.

2 Replies
Highlighted

I found the issue, which is completely different from the error message.

While the error states there's a problem with TimeGenerated, the issue is that the summarize variable name "average_committed_bytes_percent" is too long. When I changed to something much shorter like "avgram" it worked.

The error code needs to be changed. I wasted several hours trying to find out what's going on. Is there any way to send this feedback so this doesn't happen to other users?

Highlighted
This saved me from a headache. the 400 error makes no sense.