Filtering and Sorting Data in Looker Task 1

[HitkarMiglani]

I was doing Checked In Game for the Arcade. The First Task wouldn't complete although the last was completed (Last was dependent on first).  I tried it 2-3 time but still can't complete it. 

[RAOKS · Accepted solution]

After login to looker

Click on Looker

Click on Flights under FAA

expand Flight Details > Measures, click Cancelled Count

now you will see Cancelled Count on right side

expand Flights > Dimensions > Depart Date, clickWeek.

expandFlights > Dimensions > Depart Date, click on Filter symbol (reverse triangle symbol with bars) next to Date

now above above visualization you will see filter option . against Depart Date -> select ->is in the year -> then type 2004  

click on "Run"

1. Click the arrow next to Visualization to expand the window.

Once the Visualization window has expanded, you can hover your cursor over the icons to identify the available options.

1. Change visualization type to Line.

2. Click on the settings gear icon for Visualization.

3. Click Edit > Series.

4. Under Colors > Collection, select your choice of theme/color.

5. Under Point Style, click on Outline.

6. Navigate to the Y menu of the visualization setting pane, scroll down to the bottom, and click on the Add Reference Line button. Ensure that the type is set to “Line” and that the value is set to “Average (Mean)”.

7. Click on the gear icon for Visualization to close the settings.

1. Click on the settings gear icon next to Run, and select Save > As a Look.

2. Title the Look Cancelled Flight Count by Week in 2004 (ensure do not copy .(symbol) when you are saving)

3. Click Save.

Check Task, All the best, Before saving only ensure you get output similar to what is shown in Task.

[RAOKS · Accepted solution]

After login to looker

Click on Looker

Click on Flights under FAA

expand Flight Details > Measures, click Cancelled Count

now you will see Cancelled Count on right side

expand Flights > Dimensions > Depart Date, clickWeek.

expandFlights > Dimensions > Depart Date, click on Filter symbol (reverse triangle symbol with bars) next to Date

now above above visualization you will see filter option . against Depart Date -> select ->is in the year -> then type 2004  

click on "Run"

1. Click the arrow next to Visualization to expand the window.

Once the Visualization window has expanded, you can hover your cursor over the icons to identify the available options.

1. Change visualization type to Line.

2. Click on the settings gear icon for Visualization.

3. Click Edit > Series.

4. Under Colors > Collection, select your choice of theme/color.

5. Under Point Style, click on Outline.

6. Navigate to the Y menu of the visualization setting pane, scroll down to the bottom, and click on the Add Reference Line button. Ensure that the type is set to “Line” and that the value is set to “Average (Mean)”.

7. Click on the gear icon for Visualization to close the settings.

1. Click on the settings gear icon next to Run, and select Save > As a Look.

2. Title the Look Cancelled Flight Count by Week in 2004 (ensure do not copy .(symbol) when you are saving)

3. Click Save.

Check Task, All the best, Before saving only ensure you get output similar to what is shown in Task.

[HitkarMiglani]

Hii Thank you for your advice. But i have tried all ways, it still doesn't mark as completed.

[RAOKS · Accepted solution]

It is very easy lab, carefully study lab three to four times. understand.

If you are doing looker first time you need to understand about Dimensions, Measures, Filters,

In Visualization- Table, map, line, etc

In Visualization -Settings-> go through all options. I am sure you will succeed.

[HitkarMiglani]

There was a minor Mistake, I accidently applied filter on Date Week but it was required on Date itself. Now I have completed the Lab. 
Thanks to all.

[RAOKS]

Good to know you completed lab.