search

aws-samples / aws-serverless-workshop-innovator-island

Welcome to the Innovator Island serverless workshop! This repo contains all the instructions and code you need to complete the workshop.
MIT No Attribution
564 stars 228 forks source link

In QuickSight 'ride rating' visualisation, setting colour rating aggregation to 'Average' isn't possible #59

Closed stylesm closed 3 years ago

stylesm commented 3 years ago

Describe the bug In 'Building visualizations #4' (the tree map), aggregating rider rating by average isn't possible

Link to workshop URL https://www.eventbox.dev/published/lesson/innovator-island/5-parkstats/3-quicksight/4-visual.html#step-by-step-instructions

To Reproduce Steps to reproduce the behavior:

  1. Go to https://www.eventbox.dev/published/lesson/innovator-island/5-parkstats/3-quicksight/4-visual.html#step-by-step-instructions
  2. Follow instructions 1-9 to create the visual
  3. In step 10, "Click the dropdown arrow next to the rating field in the well, select the Aggregate sub-menu and choose Average"
  4. Observe that the only available options are 'Count' or 'Count distinct'.

Expected behavior 'Average' should be an option for rating aggregation.

Screenshots image

Desktop (please complete the following information):

Smartphone (please complete the following information):

Additional context N/A

jbesw commented 3 years ago

Thanks for raising this issue! https://www.eventbox.dev/published/lesson/innovator-island/5-parkstats/1-firehose.html has been updated with new instructions on converting the "rating" data type to an integer, which resolves this issue.