I'm hitting a wall on this one... My data set is relatively simple. Yet for some reason, I'm not getting the right totals.
I am only dealing with two fields at this time: a Date/Time field, and an Employee field. I need to graph the number of Conditions ordered over time, with respect to employee. Ideally, Something like this:
To achieve the graph above, I have used the following setup:
Dimension 1: [ConditionOrdered.autoCalendar.Date]
Dimension 2: Employee
It seems like this should work, but the totals are off from what they should be. As an example, I have attached data from the most recent business day. Without the [Employee] dimension, the graph shows that there were 109 orders made, whereas with the [Employee] dimension, I get a total of 103. It makes sense that the two blanks in the [Employee] field would not be counted, but that does not account for another four that aren't being counted.
Has anyone had a similar issue when including a second dimension? Any ideas for solutions?
The only manipulation that I can see is what Qlik did automatically.
The format in Excel is MM/DD/YYY hh:mm. The data is loaded into Qlik with the timestamp() function and assigned to the autoCalendar.
My data set is larger. I just singled out one day to make things simpler.
Yes, the straight table has the correct total. The pivot table does as well. However, if we set the graph that you made to a stacked area graph, it does not have the correct total. This is the same problem that I am facing. (Notice that even with null values included, the stacked total is only 104, where it should be 109.)
When I select Bree or Isabel from the legend, no dots are highlighted. This would account for the lost 5 orders, but why would they not be included in the graph?
When Bree is selected:
When Emily is selected: