How do I create level based metrics in Data Visualization?

User_JA6EI · Feb 2, 2018 8:00AM

Summary

Hi,

I have a dataset as below:

I need to show the location that have less than 10% of total revenue as 'Misc'

So, the metric definition would be,

Location_Name_New = CASE WHEN Sum(Revenue By Location) / Sum(Revenue) < 0.1 THEN 'Misc' Else Location End

How do I calculate this in DV? The moment I remove the Location field from the visual, all the Location_Name_new become Misc.

This is the calculation:

And the output is as below:

But what I need is this:

But the moment I remove Location from report, it goes back to showing all locations Under Misc.