Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

show previous weeks data based on selection

I have the below expressions that I want to plot on a graph (it returns an amount of time). I want the graph to plot the Maximum available "Week" (which is a field in my table) and then the previous n weeks (will probably be 13 but I should be able to change it in the expression)

sum(if(Left(TaskType,4)='PACK',WorkTimeAverage))/sum(if(Left(TaskType,4)='PACK',LineQty))

0 Replies