This content has been marked as final. Show 2 replies
I have stuck in creating one visualization where I need to have column average into one variable.
I have couple of million records which are basically shows Good quality and Poor Quality of specific item. The item is being used across the globe.
What I am trying to achieve is - I want to calculate an average of Poor OR Good quality records.
I can get it by following steps as Analysis -> Totals -> Total All Using -> Average. But I cannot save this average outcome into one variable.
Is there any way that I can get the value into one variable to compare it with each country's average so that I can have performance of each country with respect to Global average?
I hope my explanation about the scenario is quite clear to understand.
Please let me know if you need any more info.
I will try to attach sample file shortly.