Hi everyone, I'm working on a column chart to visualise the number of items in different states (e.g., State A, State B, State C) over time, grouped by week. The dataset includes: • Item ID • Item State (e.g., State A, State B, State C) • Effective Date (indicating when an item transitioned to a new state) For example: • Week 1: 5 in State A, 3 in State B, 2 in State C • Week 2: 1 item moves from State A to State B → 4 in State A, 4 in State B, 2 in State C I'm using a cumulative metric to track the number of items in each state over time. Insight configuration: Metric: SELECT RUNSUM(SELECT(COUNT(Item ID))) View By: Effective Date Stack By: Item State The issue: If no items move into a specific state during a week (e.g., no change in State C), the column chart doesn't display that phase for the week—even though there are still items in that state. Question: How can I configure the column chart (or metric) to always display all phase types for each week, even when the item count remains unchanged? Any guidance or MAQL suggestions would be greatly appreciated! Thanks.

Hello Sneha, if I understand correctly, you are working in the Platform environment. Therefore, you will need to utilize an IFNULL clause to pull in any null values. However, please note that with running totals like this, you will need to load the dates for those days, as the ifnull function does not create data for days that don't exist. Therefore, you will need to ensure those dates exist in your source data

Thank you.