Forum Discussion

nbmalla's avatar
nbmalla
Frequent Visitor
2 years ago
Solved

Pivoting and merging

Hi everyone. Hope you all are doing great. I got two pieces of data to visualize. One for sales and one for transactions. Records are weekly and placed in different sheets. Transaction2022,Transac...
  • lbendlin's avatar
    2 years ago

    First step is to bring your data into a usable shape.  You list 2022 and 2023 data but your calendar ony covers 2023 - I would rethink that.

     

    Next step is to adjust your data model

     

     

    With that you can now create your visuals according to your needs.