To GoodData homepage

Topics started by Lena

7 Topics

L
LenaKnown Participant
asked in Metrics and MAQL

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

Hi,I want to get the latest Date group by a attribute in mm/dd/yyyy format.My code is :select MAX(Date (Ticket Created Date)) BY EntityIDAnd I edit “Metric format” to “mm/dd/yyyy” format, but it doesn’t work.Do you have any better idea?Thanks for your help!

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

Are there any ways to display the current date in an insight?

Hi guys,I want to display a custom metric that is the current date + 90 days. I have a custom metric isAnd on the report it is displaying as a number, are there any ways to convert it to date format? Thanks for your help,Lena  

1
Moises Morales
GoodData Employee
1 year ago
L
LenaKnown Participant
asked in Dashboards and Reports

Can not get max of date at the higher level

Hi there,I'm facing a big problem that I’m not able to get the maximum of date group by at rows, my insight will break down by that date level.I want to get the most recent listing date of “Subdivision Name” and “Region Name”, example at Subdivision is ‘Crane Landing’ has “Most Recent Listing Date” = ‘02/21/2022’.  Any ways to do this?Thanks for your help!

1
Julius Kos
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

Hi there,I’m creating a metric with a condition that is looking for a value in the attribute value list, but that value doesn't exist in the Attribute values appearance, my case: ‘Vacant’ value doesn’t appear at this time, maybe it will be in the future.How could I use it anyway?Thank you!

5
Iva Gasparekova
GoodData Employee
2 years ago
L
LenaKnown Participant
asked in Data sources

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

Hi there,I’m facing an issue that “Data distribution worker failed. Reason: No suitable target projects found to load data.” in service workspace when loading data to all clients.Could you help me take a look? I have no idea on this. Thank you!

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

Custom a DateDifff Key performance Indicator in MAQL

Hi there everyone, I want to be able to average number of days between Listing Date and Today. My metric looks as follow: Then I put the metric AVG of Vacant Days on dashboard and it has an error:Is it possible to calculate directly on Gooddata instead of creating a view in DW?Thanks a lot,Lena

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

Cannot pull multiple Date dimensions into one Insight

Here is my Logical Data Model:For each WorkOrder have Ticket Created Date, Wo Created Date,… dimensions, when I add Ticket Created Date dimension then I can not use  Wo Created Date or others in the same insight. I have to work around that I created a view to convert other Dates to text to display on the report (Ticket Created Date Text, Wo Created Date text,...).Do we have any solution or better ways of this? Please help me.Thank you so much!

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