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.

      Updated

      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.

       

      Regards,

      Vikas