I'm trying to create a vis that shows the most current 6 weeks, but then gives an average for the entire period. For this example, the average time should be 375.9 minutes. When I add a date filter, it only gives an average for the 6 weeks selected.
1 answer
Hi @Jennifer Gaskill ,
Using a Level of Detail Calculation you can calculate the average before filtering the data:
{FIXED: AVG([Avg Time (Min)])}(see attached workbook how this works out)
Is this what you are looking for?
Kind regards,
Johan de Groot
