Pulse table still not displaying custom column names

Hi, I'm having trouble with the formatting of my pulse emails

I've already found this issue: 11655 pulse custom names by flyingmachine · Pull Request #11685 · metabase/metabase · GitHub

But this says it was fixed in v0.34, and we're running v0.37.9

Basically, the column headers that I've specified in the question are not being shown in the pulse email, it's instead showing the original column name (or the combination for joined columns)

Example

Question column:
image

Pulse column:
image

Any help with this would be appreciated, thanks

Hi @mattblanc
It works for the base table's columns, but not join table's columns. I have created an issue for it:
https://github.com/metabase/metabase/issues/16320 - upvote by clicking :+1: on the first post

Hi @flamber

The example screenshot is of a column on the base table.

I can see in your gh issue that the base table column headers were working for you, but that's not what I've seen unfortunately.

@mattblanc Okay, then I would need to see question details to have a better understanding of why it's different for you, so go to the URL /api/card/123 where 123 is your question ID.
Note that it might contain some sensitive parts (like creator and collection), which I don't need.

@flamber No worries, thanks for taking a look.

I'll paste that data below, just wanted to call out that there are a bunch of joined columns (so I realise they're covered by the issue you linked).

The one that isn't behaving like I would expect is the 'last_mastery' column. It's on the base table, and I've renamed it to 'Date finished' in the question, but it's showing up as 'last_mastery' on the pulse table.

Here's the details:

{
"description": null,
"archived": false,
"collection_position": null,
"table_id": 264,
"result_metadata": [
    {
        "base_type": "type/Text",
        "display_name": "student_id",
        "name": "student_id",
        "special_type": "type/FK",
        "fingerprint": {
            "global": {
                "distinct-count": 380,
                "nil%": 0.0
            }
        }
    },
    {
        "base_type": "type/Date",
        "display_name": "last_mastery",
        "name": "last_mastery",
        "unit": "day",
        "fingerprint": {
            "global": {
                "distinct-count": 320,
                "nil%": 0.0
            },
            "type": {
                "type/DateTime": {
                    "earliest": "2018-03-27T14:06:36.34Z",
                    "latest": "2021-06-01T03:41:22.657Z"
                }
            }
        },
        "special_type": null
    },
    {
        "base_type": "type/Text",
        "display_name": "Student Summary - student_id → first_name",
        "name": "first_name",
        "special_type": "type/Name",
        "fingerprint": {
            "global": {
                "distinct-count": 3572,
                "nil%": 0.0
            },
            "type": {
                "type/Text": {
                    "percent-json": 0.0,
                    "percent-url": 0.0,
                    "percent-email": 0.0,
                    "percent-state": 0.0058,
                    "average-length": 5.8096
                }
            }
        }
    },
    {
        "base_type": "type/Text",
        "display_name": "Student Summary - student_id → last_name",
        "name": "last_name",
        "special_type": "type/Name",
        "fingerprint": {
            "global": {
                "distinct-count": 6965,
                "nil%": 0.0
            },
            "type": {
                "type/Text": {
                    "percent-json": 0.0,
                    "percent-url": 0.0,
                    "percent-email": 0.0,
                    "percent-state": 1.0E-4,
                    "average-length": 6.6723
                }
            }
        }
    },
    {
        "base_type": "type/Text",
        "display_name": "Class Summary - class_id → class_name",
        "name": "class_name",
        "special_type": "type/Name",
        "fingerprint": {
            "global": {
                "distinct-count": 2972,
                "nil%": 0.0
            },
            "type": {
                "type/Text": {
                    "percent-json": 0.0,
                    "percent-url": 0.0,
                    "percent-email": 0.0,
                    "percent-state": 2.584647195657793E-4,
                    "average-length": 8.069268544843629
                }
            }
        }
    },
    {
        "base_type": "type/Integer",
        "display_name": "Student Summary - student_id → year_level",
        "name": "year_level",
        "special_type": "type/Category",
        "fingerprint": {
            "global": {
                "distinct-count": 13,
                "nil%": 0.0
            },
            "type": {
                "type/Number": {
                    "min": 1.0,
                    "max": 13.0,
                    "avg": 7.7128,
                    "sd": 1.3831512826683403,
                    "q1": 6.899814451711577,
                    "q3": 8.567655873651129
                }
            }
        }
    },
    {
        "base_type": "type/Text",
        "display_name": "Account - school_id → Name",
        "name": "Name",
        "special_type": "type/Name",
        "fingerprint": {
            "global": {
                "distinct-count": 9616,
                "nil%": 0.0
            },
            "type": {
                "type/Text": {
                    "percent-json": 0.0,
                    "percent-url": 0.0,
                    "percent-email": 0.0,
                    "percent-state": 0.0,
                    "average-length": 46.98866826073397
                }
            }
        }
    },
    {
        "base_type": "type/Text",
        "display_name": "User - OwnerId → FullName",
        "name": "FullName",
        "special_type": "type/Name",
        "fingerprint": {
            "global": {
                "distinct-count": 3403,
                "nil%": 0.0
            },
            "type": {
                "type/Text": {
                    "percent-json": 0.0,
                    "percent-url": 0.0,
                    "percent-email": 0.0,
                    "percent-state": 0.0,
                    "average-length": 13.106550218340612
                }
            }
        }
    }
],
"creator": {
    "email": "REDACTED",
    "first_name": "REDACTED",
    "last_login": "2021-06-01T01:48:49.416809Z",
    "is_qbnewb": false,
    "is_superuser": true,
    "id": 4,
    "last_name": "REDACTED",
    "date_joined": "2019-02-05T05:09:47.753Z",
    "common_name": "REDACTED"
},
"can_write": true,
"database_id": 2,
"enable_embedding": false,
"collection_id": 61,
"query_type": "query",
"name": "REDACTED",
"dashboard_count": 0,
"creator_id": 4,
"updated_at": "2021-06-07T22:36:57.488126Z",
"made_public_by_id": null,
"embedding_params": null,
"cache_ttl": null,
"dataset_query": {
    "type": "query",
    "query": {
        "source-table": 264,
        "filter": [
            "and",
            [
                "=",
                [
                    "field-id",
                    6330
                ],
                2021
            ],
            [
                "not-empty",
                [
                    "joined-field",
                    "Student Summary - student_id",
                    [
                        "field-id",
                        1767
                    ]
                ]
            ],
            [
                "time-interval",
                [
                    "field-id",
                    6331
                ],
                -7,
                "day",
                {
                    "include-current": true
                }
            ],
            [
                "=",
                [
                    "joined-field",
                    "User - OwnerId",
                    [
                        "field-id",
                        1915
                    ]
                ],
                "REDACTED"
            ]
        ],
        "joins": [
            {
                "fields": [
                    [
                        "joined-field",
                        "Student Summary - student_id",
                        [
                            "field-id",
                            1767
                        ]
                    ],
                    [
                        "joined-field",
                        "Student Summary - student_id",
                        [
                            "field-id",
                            1761
                        ]
                    ],
                    [
                        "joined-field",
                        "Student Summary - student_id",
                        [
                            "field-id",
                            1751
                        ]
                    ]
                ],
                "source-table": 50,
                "condition": [
                    "=",
                    [
                        "field-id",
                        6281
                    ],
                    [
                        "joined-field",
                        "Student Summary - student_id",
                        [
                            "field-id",
                            1756
                        ]
                    ]
                ],
                "alias": "Student Summary - student_id"
            },
            {
                "fields": [
                    [
                        "joined-field",
                        "Account - school_id",
                        [
                            "field-id",
                            189
                        ]
                    ]
                ],
                "source-table": 9,
                "condition": [
                    "=",
                    [
                        "joined-field",
                        "Student Summary - student_id",
                        [
                            "field-id",
                            1752
                        ]
                    ],
                    [
                        "joined-field",
                        "Account - school_id",
                        [
                            "field-id",
                            769
                        ]
                    ]
                ],
                "alias": "Account - school_id"
            },
            {
                "fields": [
                    [
                        "joined-field",
                        "User - OwnerId",
                        [
                            "field-id",
                            1915
                        ]
                    ]
                ],
                "source-table": 8,
                "condition": [
                    "=",
                    [
                        "joined-field",
                        "Account - school_id",
                        [
                            "field-id",
                            215
                        ]
                    ],
                    [
                        "joined-field",
                        "User - OwnerId",
                        [
                            "field-id",
                            148
                        ]
                    ]
                ],
                "alias": "User - OwnerId"
            },
            {
                "fields": [
                    [
                        "joined-field",
                        "Class Summary - class_id",
                        [
                            "field-id",
                            1737
                        ]
                    ]
                ],
                "source-table": 49,
                "condition": [
                    "=",
                    [
                        "joined-field",
                        "Student Summary - student_id",
                        [
                            "field-id",
                            1748
                        ]
                    ],
                    [
                        "joined-field",
                        "Class Summary - class_id",
                        [
                            "field-id",
                            1731
                        ]
                    ]
                ],
                "alias": "Class Summary - class_id"
            }
        ],
        "breakout": [
            [
                "field-id",
                6281
            ],
            [
                "datetime-field",
                [
                    "field-id",
                    6331
                ],
                "day"
            ],
            [
                "joined-field",
                "Student Summary - student_id",
                [
                    "field-id",
                    1767
                ]
            ],
            [
                "joined-field",
                "Student Summary - student_id",
                [
                    "field-id",
                    1761
                ]
            ],
            [
                "joined-field",
                "Class Summary - class_id",
                [
                    "field-id",
                    1737
                ]
            ],
            [
                "joined-field",
                "Student Summary - student_id",
                [
                    "field-id",
                    1751
                ]
            ],
            [
                "joined-field",
                "Account - school_id",
                [
                    "field-id",
                    189
                ]
            ],
            [
                "joined-field",
                "User - OwnerId",
                [
                    "field-id",
                    1915
                ]
            ]
        ]
    },
    "database": 2
},
"id": 735,
"display": "table",
"visualization_settings": {
    "table.columns": [
        {
            "name": "student_id",
            "fieldRef": [
                "field-id",
                6281
            ],
            "enabled": false
        },
        {
            "name": "last_mastery",
            "fieldRef": [
                "datetime-field",
                [
                    "field-id",
                    6331
                ],
                "day"
            ],
            "enabled": true
        },
        {
            "name": "first_name",
            "fieldRef": [
                "joined-field",
                "Student Summary - student_id",
                [
                    "field-id",
                    1767
                ]
            ],
            "enabled": true
        },
        {
            "name": "last_name",
            "fieldRef": [
                "joined-field",
                "Student Summary - student_id",
                [
                    "field-id",
                    1761
                ]
            ],
            "enabled": true
        },
        {
            "name": "class_name",
            "fieldRef": [
                "joined-field",
                "Class Summary - class_id",
                [
                    "field-id",
                    1737
                ]
            ],
            "enabled": true
        },
        {
            "name": "year_level",
            "fieldRef": [
                "joined-field",
                "Student Summary - student_id",
                [
                    "field-id",
                    1751
                ]
            ],
            "enabled": true
        },
        {
            "name": "Name",
            "fieldRef": [
                "joined-field",
                "Account - school_id",
                [
                    "field-id",
                    189
                ]
            ],
            "enabled": true
        },
        {
            "name": "FullName",
            "fieldRef": [
                "joined-field",
                "User - OwnerId",
                [
                    "field-id",
                    1915
                ]
            ],
            "enabled": true
        }
    ],
    "column_settings": {
        "[\"ref\",[\"field-id\",1767]]": {
            "column_title": "First name"
        },
        "[\"ref\",[\"field-id\",1761]]": {
            "column_title": "Last name"
        },
        "[\"ref\",[\"field-id\",1751]]": {
            "column_title": "Year"
        },
        "[\"ref\",[\"field-id\",1737]]": {
            "column_title": "Class"
        },
        "[\"ref\",[\"field-id\",1915]]": {
            "column_title": "SIC"
        },
        "[\"ref\",[\"field-id\",6331]]": {
            "column_title": "Date finished"
        },
        "[\"ref\",[\"field-id\",784]]": {
            "column_title": "School name"
        },
        "[\"ref\",[\"field-id\",189]]": {
            "column_title": "School"
        }
    },
    "table.pivot_column": "year_level",
    "table.cell_column": "class_name"
},
"collection": {
    "description": null,
    "archived": false,
    "slug": "REDACTED",
    "color": "#509EE3",
    "name": "REDACTED",
    "personal_owner_id": null,
    "id": 61,
    "location": "/5/60/",
    "namespace": null
},
"created_at": "2021-06-02T00:09:15.329598Z",
"public_uuid": null

}

@mattblanc Okay, so here's the kicker. You are not just displaying a table, but you are aggregating, and because of that, then you are seeing issue https://github.com/metabase/metabase/issues/3735
This is because it's not getting the plain column in result_metadata, but a binned version of that (dataset_query.query), which then makes the Pulse not being able to detect the matching visualization_settings.column_settings
We are working on making Pulse visualizations match what you see in GUI, but it's a big, difficult project.

Ahh, right. Makes sense.

Thanks for your help :+1: