best visualization to show "trend" of non-quantitative measure values
I am working in Qlik Sense 3.2. I am trying to show a "trend" of a non-quantitative measure values. The measure is for a field that has one of two values -- 'pass' or 'fail'. The dimension is a date field. I would normally use a line or bar chart for this situation, and I know that I can map the two non-quantitative measure values to quantitative values (e.g., 1/0). However, the user does not want to mentally transform the numerical measure values back to the original non-quantitative values. He / she wants the visualization to simply show some icon (e.g., a bar, or a point) that is associated to the measure values "pass" and "fail" for each date. How can I achieve this?
Is there somewhere where I can find interesting ways of showing this type of data? I have a situation where the business makes appointments for treatment - treatment then starts some time after. The problem is that some people are waiting quite some time and administrators need to "see" the problem and then try and address it - if the wait could be predicted that would be "the holy grail". I have already done a stacked bar graph that counts the number of people waiting in bands of 10 mins ... looks something like this ... showing that on June 2, 40 people waited for 10 mins etc,but I am looking for ideas perhaps using the other types of default charts in Qlikview.
It's an interesting data set. A couple of thoughts. I would divide the problem into "insights" and "KPIs". For the insights I would try a gaant chart showing each individual and the time they waited. That might show patterns, outliers and choke points at certain times of the day.
For KPIs, I would calculate something like "90% of the people were seen in x minutes". I assume you already have the wait time for each person so using the Fractile(waittime, .n) might produce some interesting statistics, particularly if plotted over time, provider or treatment type.
An hourly box-plot might be insightful as well.
Do you have some sample data? I'd like to take a crack at it if I can find the time.