Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody
I don't find a solution for this topic
in Qliksense i have a table
Dimension : year (date) & '-' & num (month (date),'00')
Expression : median (aggr ((Num#(Interval(FirstPublicReply - date, 'ss'))/60),ticketid, date))
I want to have the total résult but line by line
so this result
with this formula i have the final result but not month by month always the final result (4,58)
Median(TOTAL Aggr((Num#(Interval(FirstPublicReply - date, 'ss'))/60), ticketid, date))
and not this
thank you to help me 🙂 Phil
Have you tried using the modifiers included in the measure?
Hi thanks for your reply non this is the result 🙂