Topics started by youngcat06
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
Already have an account? Login
Login to the community
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.