HI All,
I would like to show a date as a headline component. Is this possible?
I am using GDCN 1.6
E.g. from my dataset, I want to show what is the `select max(date)`
Best answer by Joseph Heun
View originalHI All,
I would like to show a date as a headline component. Is this possible?
I am using GDCN 1.6
E.g. from my dataset, I want to show what is the `select max(date)`
Best answer by Joseph Heun
View originalThe metric to display a MAX date would like something like the following based on your LDM and connection point:
Select MAX (SELECT DATE (date) By Connection Point
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
Hi Carson,
I may have misspoke as it works differently with dates in headline reports. You may need to try something like the following:
```
SELECT MAX ((SELECT (10000 * MAX( Year Snapshot))) + (100 * MAX(Month (Snapshot))) + (MAX(Day of Month (Snapshot))) BY Connection point)) WHERE (SELECT COUNT(Date (Snapshot), Connection point) BY Year (Snapshot), ALL OTHER) > 0
```
The final step will be apply the following number formatting:
```
[=null]N/A;
####-##-##
```
However, you say that you are looking for a max(start_time) is this for an attribute time dimension rather than a date dimension?
Hi Joseph,
This “start_time” field is a date dimension.
This is a single-table example, so there is no connection point.
Hi Joseph Heun, do you have any update on this question? Thanks
Sign in with your community account. This is different than your login to your GoodData account. Don't have a community login? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.