I have a set of conversations logged in with DATE attribute. I’d like to measure the median count of conversation per day.
However, when I enter something like
SELECT MEDIAN(COUNT(conversation_id)) BY Date (Start Date)
it doesn’t seem to work, and instead give me the total count, not the median count by date. Am I missing something? How could I get the median count of conversations? Thanks so much
Best answer by Moises MoralesView original