Is it possible to create a Metric for the "last known value"

Question

I’ve got a strange one that I’m wondering if anyone has seen and been able to find a way around. I’m trying to build a dashboard which shows headline Economic stats from various datasets. The problem is, the datasets are all updated at different frequencies, some monthly, some quarterly. The figure I’m trying to display is the “most current value” for each of the metrics. Some are current from this month (Feb 2023), others are current from last month (Jan 2023), and others are current from three months ago. Without having to configure the KPI or Metric for a “static” date, can anyone think of a way of doing this? Below screenshot shows an example of a couple of the datasets.

icon

Best answer by Francisco Antunes 16 February 2023, 12:21

View original

Francisco Antunes · Accepted Answer

Hi Mark,In this case, I think the MAX function would achieve the results you are looking for. As our support articleMAXdescribes, this function can be used to display the maximum value.How exactly you implement this function will depend on how your Logical Data Model is set up. In its most basic form, you’d be looking at a query like so:SELECT [desired value] WHERE MAX(Date)This would display only the most recent entry (i.e., the one where the Date value is the maximum).You can also refer to this Classic articleFinding Min and Max Dates Using Date Arithmetic. It is for an older version of the product, so some aspects of the UI may be different than what you are used to, but the logic there still checks out.In order to create a solution that better matches your data, please give us a bit more information about how it is configured in GoodData. A more in-depth explanation of how your data is set up, or a screenshot of your LDM, would be most helpful in this case.Best regards,Francisco

Francisco Antunes · Answer

I would also like to suggest some additional reading, to help you better understand how Dates work in GoodData. See below:

Dates and Times - This article has a comprehensive explanation on how GoodData handles Date values and how it structures them in the LDM (Logical Data Model).
Filters in the GoodData Platform - This one contains information about using Filters in GoodData (including filtering using Dates).
I would also suggest checking out the following GoodData Community posts raised by other users, with interesting questions about using Dates in our product:
- How can I custom a attribute or metric in Date format?
- Data update

I hope these are helpful! Let us know if you would need any more help.

All the best,

Francisco

Is it possible to create a Metric for the "last known value"

2 replies

Reply

Reply

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded