Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Need help Finding a Formula to use

I have this data that I want to use. I want to create visulizations by division but as you can see two providers work at multiple locations. How can I make sure those people are routed to the correct division so it doesn't skew my numbers when I start creating visualization?

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I would add a "Location 2" column.

     

    --Nate

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Can you elaborate on what you are worried about and what you would like to see happen?
    Theoretically, they could be routed to the correct division. what visual objects do you intend to create? What values are you going to put into the visual objects?

    Best Regards,
    Dino Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      When I use a matrix table to show the values for each division, it is combining the providers values and showing the total in each division.

       

      Ex: Moore has 21 units for division ABC and 12 for division BBB. When I use the matrix to look at units by divisons instead of showing that Moore as 21 for ABC & 12 for BBB, it is showing 32 for ABC & 32 for BBB.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous ,

        I'm sorry but could you show me how you created the matrix? I've tested it and I don't have any problems with it.

         

        Best Regards,
        Dino Tao
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.