@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
}