Forum Discussion

OntheDAXside's avatar
OntheDAXside
Frequent Visitor
3 years ago

Please I need help. I have a table with months, number of days, and total number of hours. I need to show this information on my visualization as seen on the second table.

 

table
monthnumber of daysnumber of hours     
January22176     
February23184     
March22176     
April25200     
May22176     
June24192     
July23184     
August25200     
September22176     
October25200     
November22176     
December20160     
        
        
        
visual 
DeptTeamNameJunejune hrs  Chargeable hrs 
Fooddddddaaaaa160192 110 
Waterdddddbbbb177192 29 
Waterdddddccccc190192 144 
Waterddddddddd184192 135 
Waterdddddeeeee168192 0 
Waterdddddfffff184192 136 
Clothesdddddggggg176.75192 86 
Clothesdddddhhhhh184192 114.75 
Clothesdddddiiii180.5192 32.25 
Clothesdddddjjjjj128192 76 
Clothesdddddkkkk104192 32 
Clothesdddddllll184192 139.25 
Clothesdddddmmmm184192 125 
Clothesdddddxxxxx184192 134 
Housedddddvvvvvv184192 23.5 
Housedddddqqqqqq86192 1 
Housedddddwwwwww189.5192 40.5 
Housedddddzzzzzzz160192 84