I am new to Looker and I am trying to show the median value by day. If I have the following data, how would I calculate the median of all values for each day? My goal is to display a bar chart with a single median value for each day.
| Date | Record | Value |
| 10/1/2021 | 1 | 5 |
| 10/1/2021 | 2 | 8 |
| 10/1/2021 | 3 | 9 |
| 10/2/2021 | 4 | 10 |
| 10/2/2021 | 5 | 10 |
| 10/2/2021 | 6 | 4 |
| 10/2/2021 | 7 | 5 |
My goal is to get an output that displays the following for each day:
| Goal |
| Day | Median |
| 10/1/2021 | 8.0 |
| 10/2/2021 | 7.5 |
Thank you
LinkedIn
Twitter
