running percentage of total

[ThePianoDentist]

I would like to take the running_total measure type [https://docs.looker.com/reference/field-reference/measure-type-reference#running_total],

but instead of displaying a raw number,

display it as a percentage of the total-total.
Due to ’ This means that you should not reference a running_total measure within another measure’:
I don’t think this is possible by combining measures.

I am stuck, not really knowing where to begin, to attempt to work-around this.

My overall aim is to essentially normalize the two lines in this graph (to make comparing trends easier)

[I also want it to go in reverse, i.e. running_total of 0 is 100%. running_total == total is 0%…but one problem at a time :D]

[ThePianoDentist]

the measures leading to the running_total
(I can probably provide more code if helpful, but would need to check with boss)

measure: count_sessions_event12 {
    label: "Event 2"
    description: "Only includes sessions which also completed event 1"
    type: count_distinct
    sql: ${match_id} ;;
    drill_fields: [detail*]

    filters: {
      field: furthest_step
      value: "2nd,3rd,4th"
    }
  }  

measure: dropoff_running_total {
    label: "dropoff_running_total"
    description: "dropoff_running_total"
    type: running_total
    sql: ${count_sessions_event12} ;;
    direction: "column"
    drill_fields: [detail*]
  }

[Dawid]

You can enable totals in your data table and then use the running total / grand total in a table calculation

[ThePianoDentist]

will give it a go cheers 🙂

confirmed worked perfectly

[peter_belfast]

is there a method to do this without a table calculation?