Transpose doesn't honour the order of columns

Dawid
Participant V

Two great things came to Looker last year: transpose and ability to change the order of column in next-table visualisation to allow us to move table calculations to a different place.

Unfortunately when using Transpose, the order is not preserved.

This is what it looks like now:


and this is what the order looks like after transposition:

image

As you can tell the Posted Booked Rooms go back to the third place .

When you re-run the query the measures that have been moved are honoured by transpose but the table calculations, unofortunately, are ignored. It would be nice to check it.

4 14 2,066
14 REPLIES 14

Dawid
Participant V

Just wondering if this has been looked at? The “new” table visualisation is our new default and yet this isn’t working correctly

Just commenting to follow up if there has been any updates on this feature.

Niki1
Participant I

Hello!
I came across the exact same problem.
I transposed my table as well and I’d like to have the correct order of the rows no.

Is there a solution?

Naomi_Johnson
Participant III

Hi,

I wonder if doing something like this could be a solution for now: https://help.looker.com/hc/en-us/articles/360023862233-Transpose-Table-Display-Measures-as-Rows-

Naomi

Dawid
Participant V

One transpose button vs changing codebas and creating dimension, table calculations, etc. If you don’t have a Developer privileges on your instance, you won’t be able to do it anyway. Not to mention people who just want to click a button like they can in Excel, won’t be able to do all that.. 

I just learned to live without it or with all table calculations at the bottom.. 

Naomi_Johnson
Participant III

I definitely agree with that, and it’s not a complete solution.

It may be worth doing in a couple of cases if transposing is absolutely necessary.

Niki1
Participant I

@Dawid What I did now is making a calculated field out of each and every single field of my table, because those you can adjust and their order will be maintained also after transposing.

Then “Hide from Visualization” all normal columns.

Super annoying but fortunately does the job.

Dawid
Participant V

I’m glad it does! Hopefully this will be looked at because it’s very much needed!

Niki1
Participant I

Yes, I agree, there is a need for a solution from Looker!
Workaround works find in some cases but it is no longterm solution.

jdufault
Participant I

I’m having similar issues and it’s creating an unprofessional experience for our sales team trying to export a report for our suppliers. The columns when pivoted, are showing in an incorrect order. Meaning all of my Column titles have switched to a random position instead of being in the first position. It used to work as intended and broke recently. I tried replacing all the fields for table calculations and the problem persists. 

6a88b7fd-5c84-42ed-9d1b-13218d088be9.png

Hoping for a solution soon!

Dawid
Participant V

Any movement on this issue Looker?

We’re Experiencing this issue too! Also, note that when we pivot the table calculations that we create end up at the end of our visualization table. But appear in the data tables correctly. A fix on this is needed otherwise a download into excel is the fix. 

Any updates from Looker on this? Also have noticed that when exporting to .csv or Excel, the data is no longer transposed.

Is there a way to export while maintaining the transposed format? 

We definitely need an updated on this!

Top Labels in this Space
Top Solution Authors