I want to add few columns and create a derived ‘total’ column in Looker ( something like total = col1 + col2).
I tried doing this through table calculations in the Look and also through a ‘running_total’ type measure in LookML. Both these approaches give me what I want.
However, when I need to download the entire data manually from the look or schedule an extract for the entire data through an email, I get the following error message
Error: Refusing to run query with no limit that Looker cannot stream incrementally. Please choose a smaller limit or remove table calculations.
Error: Refusing to run query with no limit that Looker cannot stream incrementally. Please choose a smaller limit or remove the "window" measure types (such as running_total) from the query
How can I let users download data from reports which have such derived columns? Please let me know if there is any other way I can accomplish this
Best answer by olga