I know this has been discussed in many threads in this community, but I still am unable to figure out the simplest way to solve my problem.
I have dates = time(created) I have sales = count(sales)
I would like to see on a 24 hour basis time(created) all count(distinct sales) even if there is none.
//I know there is something like this
//If I need to make a table or bar-chart on a specific period i need to.
sum(distinct if(created>=today(), sales)) //But how to get the null values?
sum(distinct if(isnull(created>=today(), sales)), ' ', sales)) //this does not work.