11th task cloud fly cup

[Sudhanshu103]

Please help me in 11th task completion of fly cup challenge . As i am struck at last task.

[SidVjSingh]

Run query, go through explore data-> studio

And do as mentioned in lab, delta sum and sort by...

It's all in the panel of data studio

[GrzWas77 · Accepted solution]

Hi,

I have the same problem with this task and after some check i do a  wrong join with tables and i forgot CAST points to INTEGER as in the Tip. First run query in BigQuery and then use Explore in Data Studio so you have direct SQL and result. Rest you must done chart line but NOT timeseries and in aggregation change to Agregation delta 🙂 

Best,

Greg