Forum Discussion

EPJones's avatar
EPJones
New Member
3 years ago

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....
Need Help
EPJones's avatar
EPJones
New Member
3 years ago

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. 

  • EPJones's avatar
    EPJones
    New Member
    3 years ago

    I could indeed just do a pivot table, but I'm asked to plop this into PBI, hence why I'm fighting with it. I'll just go ahead and re-import as a csv, I haen't tried that yet, maybe it'll remove whatever odd thing is causing PBI to count everything twice.

    Thank you for looking at my question, I really appreciate it!

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      3 years ago

      so it's a data importing issue? pls provide the original file.

      • EPJones's avatar
        EPJones
        New Member
        2 years ago

        I figured it out, thank you! Turned out my original data was corrupted somehow, and it reported twice. Thank you!