Replace missing values

[#1]

Hello

I have a problema trying to deal with missing values

I have the following tables:

In the first table I have the Max, Min and Avg of the rigth table, the problem here is in the Min expression because when a data in some date is missing the Min needs to be 0 becase that day the store didn't make transacctions,and not the mínimum value that apeear.

Other this is if a can have these two tables only in one

Thanks in advance for your help

[maxgro]

maybe you can compare (add the 2 expressions to the left chart)

count(distinct FECHA)

count(distinct TOTAL FECHA)

to know if number of date with transactions of a store is the same as number of dates