Column from table to visual.

Question

onthedaxside · Answer

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

Forum Discussion

Column from table to visual.

1 Reply

Related content

export from visual table

Table visual error

Table Visual not Matching Calculated Visual

Can't Resize Column Width in a Table Visual

Hide column from a table visual

table
month	number of days	number of hours
January	22	176
February	23	184
March	22	176
April	25	200
May	22	176
June	24	192
July	23	184
August	25	200
September	22	176
October	25	200
November	22	176
December	20	160



visual
Dept	Team	Name	June	june hrs	Chargeable hrs
Food	ddddd	aaaaa	160	192	110
Water	ddddd	bbbb	177	192	29
Water	ddddd	ccccc	190	192	144
Water	ddddd	dddd	184	192	135
Water	ddddd	eeeee	168	192	0
Water	ddddd	fffff	184	192	136
Clothes	ddddd	ggggg	176.75	192	86
Clothes	ddddd	hhhhh	184	192	114.75
Clothes	ddddd	iiii	180.5	192	32.25
Clothes	ddddd	jjjjj	128	192	76
Clothes	ddddd	kkkk	104	192	32
Clothes	ddddd	llll	184	192	139.25
Clothes	ddddd	mmmm	184	192	125
Clothes	ddddd	xxxxx	184	192	134
House	ddddd	vvvvvv	184	192	23.5
House	ddddd	qqqqqq	86	192	1
House	ddddd	wwwwww	189.5	192	40.5
House	ddddd	zzzzzzz	160	192	84