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 EntityID
And I edit “Metric format” to “mm/dd/yyyy” format, but it doesn’t work.
Do you have any better idea?
Thanks for your help!
Best answer by Michael Ullock
Hi Lena,
as this issue was discussed and resolved outside of this thread - I just wanted to follow up here.
After looking at your model, I added the primary key/connection point to your report/insight - After adding the primary key to your report I was able to add your metric into your report, which resolved this issue. The direction of the arrow determines which dataset's data can be analyzed (sliced) by the data from the other dataset. For more details on the Primary Key/Connection Point - please see the following documentation:
https://help.gooddata.com/doc/enterprise/en/data-integration/data-modeling-in-gooddata/logical-data-model-components-in-gooddata/connection-points-in-logical-data-models
https://help.gooddata.com/doc/enterprise/en/data-integration/data-preparation-and-distribution/data-preparation-and-distribution-pipeline/data-pipeline-reference/data-warehouse-reference/data-warehouse/database-schema-design/logical-schema-design-tables-and-views/primary-and-foreign-keys