To GoodData homepage

Topics started by Jean-Christophe

4 Topics

J
Jean-Christophe
asked in Dashboards and Reports

Format date as dd/mm

Hi, I’m looking at showing a specific date in a table without the year but only dd/mm. Is there any solution to change the format for that specific date ?date without yearBest regardsJean-Christophe  

2
J
1 year ago
J
Jean-Christophe
asked in Metrics and MAQL

Specific SQL keyword

Hi, Is there a a way to do a MINUS/EXCEPT like in SQL ?Objective is to count all users that are having event for something but not for something else.example :    SELECT DISTINCT LEARNER from ...    WHERE USER_ACTION_FACT_TYPE  in ('Bookmark', 'Share', 'Comment', 'Like','ArticleView'  )    MINUS    SELECT DISTINCT LEARNER from ...    WHERE USER_ACTION_FACT_TYPE in ('Training Session' ) What about INTERSECT ?    SELECT DISTINCT LEARNER from ...    WHERE USER_ACTION_FACT_TYPE  in ('Bookmark', 'Share', 'Comment', 'Like','ArticleView'  )    INTERSECT    SELECT DISTINCT LEARNER from ...    WHERE USER_ACTION_FACT_TYPE in ('Training Session' ) Best regardsJean-Christophe 

6
Joseph Heun
GoodData Employee
1 year ago
J
Jean-Christophe
asked in Metrics and MAQL

List Unused object

Hi All, Is there a way from the grey pages to list all unused metrics in KPIs, Insights, other metrics… ?Without having to check metric one by one using the Object/Used button.  Best regardsJean-Christophe 

3
Iva Gasparekova
GoodData Employee
1 year ago
J
Jean-Christophe
asked in Metrics and MAQL

Last session date

Hi all, Trying to show the last session date for each learner. I have followed this proposal to create a metric based on a date from https://help.gooddata.com/classic/en/dashboards-and-insights/maql-analytical-query-language/maql-use-cases-and-tutorials/finding-min-and-max-dates-using-date-arithmeticI use : SELECT MAX ((SELECT (100000 * MAX(Day of Month (Timestamp))) + (100 * MAX(Month (Timestamp))) + (MAX(Year (Timestamp))-2022+2022) BY Coaching Session Uuid)) WHERE (SELECT COUNT(Date (Timestamp), Coaching Session Uuid) BY Year (Timestamp), ALL OTHER) > 0and 0#/0#/#### (day/month.year format) for the format but I get crazy dates. Not sure what are these 1000000 and 100 in the metric. 

4
J
1 year ago
Welcome to the GoodData Community!Cookie settings