Skip to content
Advertisement

How to fix this order by sql consult? How to change dimension label from pie chart metabase?

I’ve been trying to build a pie chart in a metabase question, to put into my dashboard. I have player_id and updated_at columns, and I executed a consult to return the number of updated_at by day. I done this with a problem, I can’t use order by, I don’t know why but this isn’t working. So, I would like to know where I am erring.

SQL:

The column updated_at type is timestamp. A value example is: 2020-02-01 00:47:32 And another question is why I can’t set the Dimession and Meassure in Metabase, I would like to set Dimession label to respective date interval and the count number in Meassure label. Is it possible?

can I put the date interval on dimension label? Thank you, have a nice day.

Advertisement

Answer

Why not use group by?

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement