Fundamentals Capstone 5.2 format test fail.

Academy Support
1

https://learninghub.kx.com/forums/topic/fundamentals-capstone-5-2-format-test-fail

I’m having an issue witht the format for 5.2, my code for 5.1 and 5.3 pass… I attached a copy of my code and the schema for edgeProfile.


edgeProfile: select numTrds: count i, avgEdge: avg edge, minQty: min qty, maxQty: max qty by option_id from trade where date = last date, edge > avg edge

2

I found why my test was failing. Thank you

3

I'm getting the same error can you explain what is wrong here please?


4

Hi @kal8na,

I'm not sure without looking at your code, but for 5.2 you will need to ensure you are using fby or similar. You can watch this video to get a better idea of how to approach this: Fby Vs. Nested Queries - KX Learning Hub

Hope this helps,

Laura