Solved

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

• 2 replies
• 48 views

• New Participant
• 4 replies

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

2 replies

• 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:

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

All the best,

Francisco

Hi Mark,

In this case, I think the MAX function would achieve the results you are looking for. As our support article MAX describes, 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 article Finding 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