back2debug

Change bold html:{% if value == 'SUBTOTAL' %}SUBTOTAL{% else %} {{ linked_value }}{% endif %};;

group a dimension if(${products.brand} = offset(${products.brand},-1),"",${products.brand})

get the counts for changes in the dimension

if(match(${products.brand},${products.brand})=offset(match(${products.brand},${products.brand}),-1) , 1+row()-match(${products.brand},${products.brand}) , 1)

  get the subtotal
  if(

back2debug

#setting up zendesk model copied some of the blendo Zendesk block
#https://looker.com/platform/blocks/source/zendesk-analytics-by-blendo
explore: zendesk_tickets {
  join: zendesk_groups {
    type: left_outer
    sql_on: ${zendesk_tickets.group_id} = ${zendesk_groups.id} ;;
    relationship: many_to_one
  }

  join: zendesk_users {

back2debug

PSQL

create a database

• psql postgres -c 'createdb traceymartin'
• or whatever db name it tells you it can't find

---

back2debug

NPX NPM

• npx rdme docs ./documentation --key=$README_API_KEY --version=v1.9.8-DEX

• npx rdme categories --version=v1.9.8-DEX --key=$README_API_KEY

• npm run publish:rdme runs a helper script "publish:rdme": "./publish.sh --rdme && npx rdme openapi index.yml --id=$(npm run createVersion --silent --majorversion=1 --trace-uncaught) --key=$README_API_KEY --workingDirectory ./v1"

---

back2debug

AWS

confirm you have logged in successfully to aws

aws sts get-caller-identity

---

back2debug

SEARCH

history | grep what you are looking for

find / -name

---

REDIRECT TO BLACK HOLE