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]
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*]
}
You can enable totals in your data table and then use the running total / grand total in a table calculation
will give it a go cheers ๐
confirmed worked perfectly
is there a method to do this without a table calculation?