I have a system that generates reports on a daily basis. Every time a report runs, data is saved in a log table to record such things are Start Time and Status, etc... I want to create a line graph that shows you the total number of reports failed on a daily basis. This is the formula I am using in my expression editor for the MEASURE field:
=COUNT(distinct {<STATUS = {'FAILED'}>}timestamp(START_TIME, 'DD/MMM/YYYY'))
Because Start_Time is in a format that includes Hrs Min and sec, I am trying to change it to just Day/Month/Year so I can group by that and get a count for that Day.
However this is not working. Qlik just gives me a straight line, with plot points, and when I hover over the various points I see: 1 failed rpt, 5 failed rpts, 12 failed rpts, etc.. But the line graph does not go up and down, it's just a flat line.
Anyone see what I'm doing wrong?
