The chart in the table (report) is not respecting the month and year order

[danilosilva]

Good afternoon,

I’m having trouble using the Table (report) view; the grid isn’t respecting the year and month ordering.

Example:

(Correct)
Year
2024 2025

Month
January February January February

(Incorrect and what’s happening)

Year
2024 2025 2024 2025

Month
January January February February

Does anyone have a suggestion on what I can do? This is the only view that has a subtotal that stays at the bottom of the grid.

Thank you very much.

[Aamna]

have you tried sorting the years in ascending/descending order in the pivot?

[messiasSavio]

You will need to use a new field using FORMAT_DATETIME().
Example:

FORMAT_DATETIME("%Y-%m", data)

[Karthik_Gowda]

I think your Time Dimension is in a string format, you would want to convert it into Datetime

[danilosilva]

yes, I did

[danilosilva]

Yes, but I need the name of the month in Portuguese.
How could I do that?

[danilosilva]

I have a field in this format, but I need the month name.
Today in Portuguese, if I use the native Looker table view, it works normally, it just doesn’t work in this Table (Report) view that was downloaded from the Looker Store.

[Aamna]

So, if the year is already sorted in any order then for the month name field maybe you just simply need to use the month from date dimension-group and then in the format pane, for the month you may need to add %b: Abbreviated month name (e.g., Jan, Feb).

[danilosilva]

I’ll try, thank you.

[danilosilva]

I just tried again, but in the data section the order is respected by year and by month, but in the visualization, it’s not being respected.

See image below illustrating the situation.

[danilosilva]

I was looking at the formatting panel and for this view (Report) it doesn’t allow formatting the comparison field, because it’s a pivot table, so it seems to cease being considered a dimension field and is displayed in the panel.

If I use the field with numbers it works, but I absolutely need the month written out in full.

@Aamna

[Karthik_Gowda]

then maybe you’ll need to maintain another source ,for a date time dimension (like year month) to a textual dimension (like Janerio, Fevererio …) mapping. Then sort the table using the time dimension while displaying your textual dimension in the headers