Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Replies posted by av1

1 Reply

L
lookieMember
asked in Explores

Percent change and difference

i am new to looker. used the below to get the percent of previous. measure: sale_qty_change {    type: number    sql:  ${sale_qty} / offset(${sale_qty}, -1);;  } giving me an error in the explore:The Google BigQuery Standard SQL database encountered an error while running this query.Query execution failed: - OFFSET is not a function. It can only be used for array element access using array[OFFSET(position)] at [7:64] 

3
A
6 months ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service