Why are Dimension_Groups sorted "the wrong way round" for date values?

[moebe]

I have a Dimension Group for my “Delivery Date”.

dimension_group: date_from {
group_label: "gl_dim_time_del_date_from"
label: "Liefer"
description: "desc_dim_time_date_from"
hidden: no
type: time

# non standard
timeframes: [raw, date, month_name, month_num, month, quarter, day_of_month, 
quarter_of_year, year]
datatype: date
convert_tz: no

drill_fields: [drill_date_from*]
sql: ${TABLE}."DATE_FROM" ;;
}


 # DRILL FIELDS #
set: drill_date_from {
fields: [date_from_quarter, date_from_month, date_from_date]
}

If I now have a visualization in a Look, everything is good because i can define the correct visualization) 🙂
But as soon as I drill into the month, the quarter or even the day, looker reverses the order.
The newest month/quarter/day comes first, then the past ones.
But since time usually (in Europe) flows from “left” to “right”, this disturbs a lot of my customers.

Is there a “clean” way to fix this behaviour?

[er1k]

+1 here, have messed with a similar issue quite a few times.

[moebe]

is there a solution for that?

[moebe]

Hi all
i just testet this with the new dashboard beta.
drilling is now not with a normal vizualisation, but with the new table viz.
Sort order is still wrong.

It is still descending, what is for a Date just wrong.
Date is from left to right, from the past to the future.

Please please change that.

All our customers ask me to fix that!

[Cyril_MTL_Analy]

moebe:

drill_fields: [drill_date_from*]
sql: ${TABLE}.“DATE_FROM” ;; }

# DRILL FIELDS #
set: drill_date_from { fields: [date_from_quarter, date_from_month, date_from_date] }

Hey @moebe, why are you using the drill_fields parameter?

Not sure that is the issue as I just tested and could not reproduce this behavior with your code. I guess there is something else, can you post a screenshot of your viz or even better a video?

[moebe]

Hi Cyril

the drill filter are used, because we want to have the possibility to have different fields for the customer to show in a report, but only specific fields for drilling.

but i changed that for a simple example.

here a video showing the issue:

[moebe]

I’m bringing the subject up again.

I still haven’t found a good solution to sort the date “correctly” during a drill.
Correct for me means:

months:
January up, December down. --> at the moment exactly the opposite

Quarters:
Q1 up, Q4 down --> At present exactly the opposite

Days: 31.12. up, 01.01. down --> Currently reversed

I could solve this by right-clicking during drilldown and then opening in a new window, but our embed users don’t have the rights.
Also I could make the drilldowns look like my own, but that’s also not nice, because a lot of unnecessary duplicate work…