2 Replies Latest reply on Apr 15, 2018 8:12 AM by suman kumar

    How to get column average into one variable?

    Vikas Agrawal

      Dear Folks,


      I have stuck in creating one visualization where I need to have column average into one variable.


      Scenario -


      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.