Hello, I have some data with a dimesion called status which can be: "suggested", "notified", "rejected", "delivered", "accepted".
I would like to see how many proposal do I have on average per status and per day in a Funnel Chart.
Now, my measure would be:
COUNT({<status={"suggested"}>}distinct id)/COUNT(distinct Date(Floor(created_at), 'MM/DD/YYYY'))
COUNT({<status={"delivered"}>}distinct id)/COUNT(distinct Date(Floor(created_at), 'MM/DD/YYYY'))
COUNT({<status={"accepted"}>}distinct id)/COUNT(distinct Date(Floor(created_at), 'MM/DD/YYYY'))
....
In this way I have a number for ALL days.
But If I put this code in the funnel chart I get different outputs because it will only count the days where that status is true.
How can I "tell" my funnel chart to count ALL dates regardless the status?
