'Firebase User ID' dimension should default to user_id, not user_pseudo_id

[dctanugi]

In the Firebase Events view, there is a dimension called Firebase User ID that defaults to user_pseudo_id (and returns user_id instead of user_pseudo_id is null). This has the undesired effect that the number_of_users measure calculated the number of app instances, not the number of app accounts.

In other words, if a user (with a given user_id) logs into the app twice (resulting in two user_pseudo_id values), the number_of_users measure will return 2 instead of 1. That is probably not what most Looker users will expect when querying the number of users.

firebase_block_v3/events.view.lkml

Line 321 in e437323

sql: COALESCE(${user_pseudo_id},${user_id}) ;;