Running queries on really large sets of data, and sending the output to an outputlookup works well for weekly refreshed dashboards. Is there a way to have some numbers from the initial report go into a separate, second outputlookup for monthly tracking?  For example a weekly report or dashboard shows me details on a daily basis, and the weekly summary - great.  Now the weekly summary should go additionally to a separate file for the monthly view. Is there a way to 'tee' results to different outputlookups?  ... View more

Hi  need to calculate the average based on a condition.  testing=true vs testing=false  (lets say field A) field B has the values to average (milliseconds) field C has urls  something like this: | stats avg(fieldB, when field A testing true) as trueV avg(fieldB, when field A testing false) as falseV by Field C Goal is a table like this: url  | average (true) | average( false).       ... View more