This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

Best practises for Total metrics in datasets

Posted on 12-22-2023 05:47 AM
DavidSmolka
Bronze 2
Bronze 2
Reply posted on --/--/---- --:-- AM

Hi, i am just wondering what is your opinion about including TOTAL metrics in a dataset.

I have a dataset that has a metric Revenue A and a metric Revenue B. Very often, users will want to see only Total Revenue ( which equals to SUM of Revenue A and Revenue B). 

What is the best practise here - should I include the Total Revenue in the dataset, or create it as a measure in Looker? What are the pros and cons?

Thank you

0 1 278
0 Likes
Reply
1 REPLY 1
Top Labels in this Space