Forum Discussion
Text Field Counted Twice
I have a fairly simple excel spreadsheet but it's pretty long. I'm trying to visually represent how many trips per day for manpower reasons, and it counts all instances twice, I can't figure out why....
Ah yes, my apologies!
This is what I want:
January 1 - 8trips missed due to manpower
- 1 trip missed due to mechanical/engine
- 1 trip missed due to other
This is what I currently get, it double counts everything:
January 1 - 16 trips missed due to manpower
- 2 trips missed due to mechanical/engine
- 2 trips missed due to other
I'm looking for a graph that will show how many trips were missed due to manpower (in particular, others too) each day YTD.
Ashish_Mathur
Super User
Super UserHi,
Check the steps in the Query Editor. In the second/third step, then number of rows should be equal to the number of files lying in the folder from there you are importing data.