I am playing around in Qlik Sense and am fairly new. I am pretty decent with Qlikview, but there are of course subtle differences.
I created a Combo Chart with the sum and average of job run times by year, month, and day. They don't have a way to easily add trend lines in Qliksense that I have seen, so I added a formula that others had been sharing that created one, but this adds in all values without data to the chart as you can see below.
-Anyone find a good way to remove the extra months/values that are added? I've tried to tinker with all of the settings and options.
-Also, anyone find a way to choose the display of the Y-Axis? the way it splits the hours is very odd... why not just 1:00, 2:00, 3:00, ect?
Here is the trend line formula that also adds the extra zero'ed values: