I am trying to make multiple box plot that shows the length of appointment in time by days of the week. I got my visual to render but am having two problems.
1) There are only 3 box plots shown when I am looking for 5 (M-F). Filtering by days of weeks still only allows 3 to be shown.
2) It is not showing length of appt by time. It is a decimal. Here is the equation that I am using and also it will render time in a table but does not on the box plot. interval(avg(DIFF_APPT_LENGTH),'hh:mm:ss')
Thanks!