Seeking Help with Dynamic Granularity and Last Value Integration

[MarwAjmi]

Hello everyone,

I'm currently facing a challenge in Cube.js and would greatly appreciate your insights. Here's a brief overview of the issue:

Issue Overview: I am working on integrating a Cube.js query measure that depends on the last value of a numeric column within a dynamic time slot. The granularity of the time slot is dynamic, meaning it is chosen by the frontend.

Objective: I am trying to retrieve the last value within the chosen dynamic granularity.

Database Dialect: I am using PostgreSQL.

[igorlukanin]

Hi @MarwAjmi 👋 I'm not sure I fully understand the question. Could you please provide a tiny example dataset and show which results would you like to get? It would really help to understand what you're trying to achieve here.