DE2.0 Calculated Field Issue when after download the report

Follow

Frederick Tan

• January 13, 2022 04:51

I added simple calculated field on my report

if(${visit_tier_5.visit_sum_hours_approved}<1,1,${visit_tier_5.visit_sum_hours_approved})

The data table return correct value but when download the report as csv and unformatted, when opening the file I got this message below instead of data

"Refusing to run query with no limit that Looker cannot stream incrementally. Please choose a smaller limit or remove table calculations".

Any solutions rather than remove the calculated field

 

0

• 

  Alexandra Dunne

  • January 26, 2022 21:11

  Hi Frederick Tan,

  I have turned this into a ticket for our data team to investigate for you as I have been unable to find out the answer myself. 

  Alex

  0

  Comment actions Permalink

Please sign in to leave a comment.