An analyst adds a Day dimension and a Signup Count measure to an Explore to show the number of new users added per day. The analyst wants to add a metric that increases by the number of new users per day, on a rolling basis.
How should that metric be calculated?

Question

An analyst adds a Day dimension and a Signup Count measure to an Explore to show the number of new users added per day. The analyst wants to add a metric that increases by the number of new users per day, on a rolling basis.

How should that metric be calculated?

Lionel Fitzgerald Gweth · Accepted Answer

Add a Sum measure to the Explore and re-run the query.

Lionel Fitzgerald Gweth · Answer

Add a table calculation that calls running_portal (${users.signup_count})

Lionel Fitzgerald Gweth · Answer

Add a custom measure of type: running_total

Lionel Fitzgerald Gweth · Answer

Add a table calculation that calls ${users.signup_count:total}

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 3 - Looker Business Analyst discussion

Suggested answer: A

0 comments