To GoodData homepage

Replies posted by Lena

11 Replies

L
LenaKnown Participant
asked in Data sources

Data distribution worker failed. Reason: No suitable target projects found to load data.

Thank you.I worked around by mapping manually the client id to each workspace’s Automated Data Distribution.

2
L
2 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

Lookup a value not exists in the attribute value list of an attribute

Thanks for your support, but how about a value that has spaces such as ‘Trustee Occ/Eviction’, I can not add a tag with spaces.

5
Iva Gasparekova
GoodData Employee
2 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

Lookup a value not exists in the attribute value list of an attribute

Thanks for your quick reply. But I’m developing in a Master workspace and applying to all clients. That value may do not appear in this client but it will in other clients. So I can not custom a metric for each client.

5
Iva Gasparekova
GoodData Employee
2 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

Custom a DateDifff Key performance Indicator in MAQL

That means I can create a Events View on UI without referencing to a View in Data Warehouse? 

7
L
2 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

Custom a DateDifff Key performance Indicator in MAQL

Thanks for your support, Joseph.In GoodData multiple versions of time cannot be used together. In my case my LDM should be converted to use Event LDM as If Too Many Date Dimensions, Try Events - Gooddata Enterprise. It is difficult for me to implement it.Thanks,Lena

7
L
2 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

Custom a DateDifff Key performance Indicator in MAQL

Thank you, Joseph. It’s worked now after correcting:My Days = SELECT AVG(select THIS - Date (Move Out Date) BY Fct Tenant Activity History). But in case My Days is calculated from multiple dates, It will be not worked again.My example: My Days =SELECT AVG(SELECT CASE     when Occupancy Status = Status A then (select THIS - Date (Move Out Date)  By Fct Tenant Activity History)    ,when Occupancy Status = Status B then (select Date(Move Out Date) - Date(Move In Date) by Fct-Accum_Prop_Status )ELSE 0END )My LDM is as follow: Thanks for your help,Lena

7
L
2 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

How can I custom a attribute or metric in Date format?

Hi Michael,I had the issue which can not use multiple Date dimensions in one Insight, I found that this issue was fixed today, please following this link: Cannot pull multiple Date dimensions into one Insight | The GoodData Community Currently, there is still another issue, I cannot use this formula: Status DIQ: select THIS - “WO Closed Date”,   because the “WO Closed Date” haven’t included in the Insight.Example for another formula I can use: Tickets DIQ: select THIS - “Ticket Created Date”, this formula is usable because “Ticket Created Date” column is already included.Could you please take a look on this?  Thanks! 

9
Julius Kos
GoodData Employee
1 year ago
L
LenaKnown Participant
asked in Metrics and MAQL

How can I custom a attribute or metric in Date format?

Hi Michael,Thanks for your support, although it was a bit difficult to do but finally it works correctly now.MAQL Metric Format: 0#/0#/####Result:   Thanks,Lena

9
Julius Kos
GoodData Employee
1 year ago
L
LenaKnown Participant
asked in Metrics and MAQL

How can I custom a attribute or metric in Date format?

Hi Michael,In my case I have a Entity that has 4 Tickets were created in different days, the report displays the latest created Ticket date and the latest Close date for each Entity.Example: My Entity has 4 tickets something like thatTicket #                     Created Date                     Closed DateTK#1                        01/12/2021                         01/20/2021TK#2                       01/13/2021                         01/21/2021TK#3                        01/14/2021                         01/22/2021TK#4                       01/15/2021                         01/23/2021 I would like to display on the report:Entity ID                    Ticket Created Date                         Ticket Closed Date0101                        01/15/2021                                          01/23/2021                     So I custom the metric to get latest date for each Entity ID, but it is not workingselect MAX(Date (Ticket Created Date)) BY EntityID  

9
Julius Kos
GoodData Employee
1 year ago
L
LenaKnown Participant
asked in Metrics and MAQL

Cannot pull multiple Date dimensions into one Insight

Hi Boris,It works correctly right now, thank you so much!Lena

4
L
3 years ago
L
LenaKnown Participant
asked in Metrics and MAQL

Cannot pull multiple Date dimensions into one Insight

Hi Boris,Thank you for your information, but I still have a issue that I created a metric that use BY keyword to count WorkOrder  by a Property, but  instead of it have to aggregate to Property level then this metric was be broken down to WorkOrder floor. Example: I have a Property that has 6 WOs were created. Below is my Insight: I expect “WOs on Prop” is number 6, but it still was be broken down by Workorder #.Here is my code for “WOs on Prop” metric:select count(WO #) BY PropertyCould you help me take a look on this?

4
L
3 years ago
Welcome to the GoodData Community!Cookie settings