I am not able to complete this Lab activity; while creating the pie chart, I selected Payment type for label and for value and selected count for showing the counts.
Task 3. Create charts to visualize BigQuery data
Create a pie chart to identify which payment type is most frequently used to pay the fare amount.
Hello @kiranmayi
Can you tell the name of the lab you're working on?
https://partner.cloudskillsboost.google/course_templates/632/labs/464083
Apologies for the delayed reply @kiranmayi , actually I had decided to try the lab myself, but was facing issues since I am not a Google Cloud Partner (access got denied).
Somehow after some tweaks, I got the lab, and here's what I got after I tried it:
Creating pie chart is okay, label as 'payment_type' is also okay. The problem happened in the value, it should not be anything as 'count' but rather 'fare_amount'.
Hope this solves the problem! All the best!
User | Count |
---|---|
33 | |
17 | |
5 | |
2 | |
1 |