Transpose a matrix

Anonymous · ‎10-04-2019

Hi Datanauts,
I have created a matrix which is posted below...I am trying to transpose it to look like this template. these are calculated measures. So they do not show up in the query editior data view, and if I unpivot the other columns, these measures break.

How do I transpose this visual?

v-joesh-msft · ‎10-07-2019

Hi @Anonymous ,

I am not quite sure whether the row fields in the matrix are hierarchical in your template. If it is, it may be difficult to implement your results. If not, you can try to convert the row and column fields in the matrix for swapping.

If it doesn't meet your requirement, kindly share your sample data if you don't have any Confidential Information.

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎10-07-2019

Hi @v-joesh-msft ,
It is a funnel so yes it is hierarchial. PFA the sample data. Looking forward to hearing from you. Thank you!

org_id	org_name	geo_code	country	market_segment	contract_start_quarter	Provisioned	Sum of assigned_seats	QAD	Sum of downloaders	downloads	Assigned 1+	Assigned > 10%	Assigned > 50%	Consuming (1+)	Consuming (10+)
D874CD9D542D992A0A4C98	Brainlounge	JPN	JP	COMMERCIAL	2017-Q4	58	11	0	0	0	1	1	0	0	0
ECBAE18C55352B350A4C98A6	JumpXS	EMEA	GB	COMMERCIAL	2018-Q1	315	34	13	17	210	1	1	0	1	1
6BAE37875C936C6C0A495FBD	Babbleset	AMER	US	COMMERCIAL	2019-Q2	12	1	0	1	2	1	0	0	1	0
5AFA5F3E57057E367F000101	Innotype	ASIA	IN	COMMERCIAL	2019-Q2	179	173	11	59	14	1	1	1	1	1
D029B4A35717B9957F000101	Zoomcast	AMER	US	COMMERCIAL	2019-Q2	1054	1163	61	65	189	1	1	1	1	1
741524D15CBF274B0A495C93	Riffwire	AMER	BR	COMMERCIAL	2019-Q2	42	42	2	7	6	1	1	1	1	0
5211508055C89B1F7F000101	Feedspan	AMER	US	COMMERCIAL	2019-Q2	326	344	30	44	50	1	1	1	1	1
8EF1373B5CC1EE9F0A495FB9	Mydo	EMEA	NO	COMMERCIAL	2019-Q2	50	71	2	3	1	1	1	1	1	0
518A4C4E572252707F000101	Tanoodle	ASIA	AU	COMMERCIAL	2019-Q2	75	117	22	27	283	1	1	1	1	1
98B51C8B532961AB0A490D4D	Brainlounge	AMER	US	COMMERCIAL	2019-Q2	338	337	25	52	535	1	1	1	1	1
6FDF58DD55C1322D7F000101	Zava	AMER	US	COMMERCIAL	2019-Q2	266	263	21	28	40	1	1	1	1	1
F859C4A65717BC3B7F000101	Quimm	EMEA	IT	COMMERCIAL	2019-Q2	113	119	24	36	3996	1	1	1	1	1
4E6040D7544924950A4C98A2	Babbleblab	EMEA	SE	COMMERCIAL	2019-Q2	320	360	7	7	26	1	1	1	1	1
9F55515C56B50A707F000101	Photobug	AMER	US	COMMERCIAL	2019-Q2	167	189	15	28	91	1	1	1	1	1
6716FFD3544984240A4C98A5	Babbleblab	EMEA	FR	COMMERCIAL	2019-Q2	1318	122	5	15	32	1	0	0	1	1
E97C63305747438F7F000101	Skipstorm	AMER	US	COMMERCIAL	2019-Q2	126	126	6	15	4	1	1	1	1	0
B3902DB45388D9620A490D4C	Jabbercube	AMER	US	COMMERCIAL	2019-Q2	353	397	44	70	773	1	1	1	1	1
4CE5F16A5748AD3A7F000101	Realfire	AMER	US	COMMERCIAL	2019-Q2	335	278	24	35	327	1	1	1	1	1
D57A2420546E39840A4C98A2	Zoozzy	AMER	US	COMMERCIAL	2019-Q2	302	239	32	45	1360	1	1	1	1	1
5A67E38C5474FAAE0A4C98A7	Yakitri	AMER	US	COMMERCIAL	2019-Q2	350	294	30	58	3171	1	1	1	1	1
9718FFD3545D05690A4C98A5	Tagcat	EMEA	AT	COMMERCIAL	2019-Q2	66	65	1	2	3	1	1	1	1	0
9BB626F8545D1AFA0A4C98A4	Kaymbo	EMEA	DE	COMMERCIAL	2019-Q2	157	172	6	23	30	1	1	1	1	1
17FAD312548B70250A4C98A6	Jayo	EMEA	BE	COMMERCIAL	2019-Q2	107	108	10	29	44	1	1	1	1	1
19D21607552EBC000A4C98A2	Livepath	ASIA	AU	COMMERCIAL	2019-Q2	78	75	14	17	334	1	1	1	1	1
914CA272551D23790A4C98A2	Mita	AMER	US	COMMERCIAL	2019-Q2	771	654	63	75	540	1	1	1	1	1
A66F776A5245B0310A490D44	Photolist	AMER	US	COMMERCIAL	2019-Q2	673	808	14	51	0	1	1	1	0	0
C1FA079F574F01297F000101	Lazzy	AMER	US	COMMERCIAL	2019-Q2	306	273	28	73	418	1	1	1	1	1
D06DE27F546E24D40A4C98A5	Livetube	AMER	US	COMMERCIAL	2019-Q2	394	399	59	85	977	1	1	1	1	1
EB2234B85CF1A76C0A495CD7	Shufflester	AMER	US	COMMERCIAL	2019-Q2	402	455	54	100	193	1	1	1	1	1
42DF2BA2549484FB0A4C98A1	Realpoint	AMER	US	COMMERCIAL	2019-Q3	2170	3	0	0	0	1	0	0	0	0
8AA1FCB555A95FD27F000101	Innotype	EMEA	AT	COMMERCIAL	2019-Q3	719	709	71	81	1785	1	1	1	1	1
C2F4D3125489ED960A4C98A6	Kwilith	EMEA	DE	COMMERCIAL	2019-Q3	12700	214	23	27	664	1	0	0	1	1
3D00286D5750980D7F000101	Tanoodle	AMER	US	COMMERCIAL	2019-Q3	450	479	29	30	319	1	1	1	1	1
5741693F544944260A4C98A6	Chatterpoint	EMEA	SE	COMMERCIAL	2019-Q3	56	52	12	7	60	1	1	1	1	1
5AE4E38C5474FC7E0A4C98A7	Skynoodle	AMER	US	COMMERCIAL	2019-Q3	277	104	3	4	153	1	1	0	1	1
F718199053220B9F0A490D4C	Mycat	AMER	US	COMMERCIAL	2019-Q3	308	1	0	0	0	1	0	0	0	0
4A7BC38E5494B4220A4C98A2	Einti	AMER	US	COMMERCIAL	2019-Q3	1300	1673	19	48	144	1	1	1	1	1

v-joesh-msft · ‎10-08-2019

HI @Anonymous ,

From your data, I found that there are fewer fields, such as Accounts Purchased/Under 30 Days into Contract, and the calculation logic of measure in the template is harder to find.

As mentioned in the previous reply, if the rows in your template matrix are hierarchical measures, this is hard to achieve. Based on the results you want to achieve, I think you can try to create a disconnected table, check out this article: Measures on Rows – Here is How I did it

Best Regards,

Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.