search

cube-js / cube

📊 Cube — The Semantic Layer for Building Data Applications
https://cube.dev
Other
17.79k stars 1.76k forks source link

Seeking Help with Dynamic Granularity and Last Value Integration #7594

Open MarwAjmi opened 9 months ago

MarwAjmi commented 9 months ago

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 commented 8 months ago

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.