To GoodData homepage

Replies posted by Carson

5 Replies

C
CarsonParticipating Frequently
asked in Metrics and MAQL

Query Date Field for Headline insight

Hi Joseph Heun, do you have any update on this question? Thanks

6
Joseph Heun
GoodData Employee
2 years ago
C
CarsonParticipating Frequently
asked in Metrics and MAQL

Query Date Field for Headline insight

Hi Joseph,This “start_time” field is a date dimension.This is a single-table example, so there is no connection point.

6
Joseph Heun
GoodData Employee
2 years ago
C
CarsonParticipating Frequently
asked in Metrics and MAQL

Query Date Field for Headline insight

Hi Joseph,Could you clarify your answer please?To illustrate this use case -- the LDM is 1 table only. And it has a date field “start_time” --How can write a metric to return max(start_time) across the dataset?Thank you

6
Joseph Heun
GoodData Employee
2 years ago
T
tibiNew Participant
asked in Data sources

GD.CN running the same, long running query in multiple parallel sessions

Thank you, Jacek, I believe that solves it. For our use case, our table isn’t designed to have any unique PK.And so, would be preferable for us to remove this PK requirement from the GoodData LDMing.For interim, we will add an auto-increment id column as workaround.

5
D
GoodData Employee
2 years ago
T
tibiNew Participant
asked in Data sources

GD.CN running the same, long running query in multiple parallel sessions

Tibi’s colleague here -- an example of long-running query: ( SELECT "visitation_dn"."day_of_week" AS "a_label_visitation_dn_day_of_week_ba541a70e9034_ac6cb5b887df02", "visitation_dn"."destination" AS "a_label_visitation_dn_destination_ba541a70e9034_53782e75b1687b", "visitation_dn"."distance_from_home" AS "m_1" FROM "gd"."visitation_dn" AS "visitation_dn" ) Carson

5
D
GoodData Employee
2 years ago
Welcome to the GoodData Community!Cookie settings