Forum Discussion

Sudhavi_84's avatar
Sudhavi_84
Icon for Helper V rankHelper V
5 years ago
Solved

Measures to Average

Hi, I have Measures which it calculates total duration days between Stages based on project level. I can see total duration which is correct.

 

But I also would like to show the measures in Average and Median. Do I need to write new measures for Average and Median?

 

I am using Matrix visual and when I click on "Value" Fields in Matrix visual it is showing only Show value as Option like Percentage.

 

Please any help or anything I can do?

 

 

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Sudhavi_84 ,

     

    when you use a measure you have to create a new measure for each aggregation.

    So one for SUM, one for AVERAGE, one for MAX, etc.

     

    If it's a normal column you can chose the aggregation in the fields area.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Sudhavi_84 ,

     

    I was wondering if my answer solved your question?

    If that's the case I would be happy if you mark the post that helped as solution. This will help the next person with the same issue to see immediately if a solution worked or answered the question.

     

    If you have more questions I would be happy to help you 😊

     

    Best regards

    Denis

2 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Sudhavi_84 ,

     

    when you use a measure you have to create a new measure for each aggregation.

    So one for SUM, one for AVERAGE, one for MAX, etc.

     

    If it's a normal column you can chose the aggregation in the fields area.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • selimovd's avatar
      selimovd
      Icon for Most Valuable Professional rankMost Valuable Professional
      5 years ago

      Hey Sudhavi_84 ,

       

      I was wondering if my answer solved your question?

      If that's the case I would be happy if you mark the post that helped as solution. This will help the next person with the same issue to see immediately if a solution worked or answered the question.

       

      If you have more questions I would be happy to help you 😊

       

      Best regards

      Denis