How to display zero when there is no record for certain dates

[Nourrahmcnean]

Hello everyone,

I want the line of the chart to go down to zero for the dates where I don't make anys ales for example On 31/05/2022, 02-03/06/2022. And Print zero in the text box( which contains the sum of all sales of the date selected ), if I don't have sales on that date of course. How is that possible on script?

[sergio0592]

Hi,

The only way is to use a reference table of time where you have all the days. With the same name DT, link will be automatic between your fact table (Sales) and reference table.

After, you just have to ensure that you have uncheck the 'Suppress Zero Values' in Properties/Presentation tab.