Bar Chart with pre-set category

user19914
user19914 Member
in Magic ETL

I have data in the following format:

 
PersonStarting PointCurrent Point
JohnUnit 1Unit 4
JaneUnit 2Unit 5
JoeUnit 1Unit 3
SueUnit 4Unit 8
 

I would like to create a bar chart showing all the units (50 of them) with the number of people who started in each unit and how many are currently in each unit. There will be some units with no one in them, but they need to appear anyway. I've gone around and around on how to do this and am not getting anywhere.

 

 

 

Comments

  • jaeW_at_Onyx
    jaeW_at_Onyx Coach

    restructure your data. such that your columns are

     

    Activity Type, User, Unit, rowCount

    Current, John, Unit 1 , 1

    Start , Jonn , Unit 4, 1

    Current, Jane, Unit 3, 1

    Start, Jane , Unit 2, 1

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Categories