Forum Discussion

nzkevin003's avatar
nzkevin003
Frequent Visitor
7 years ago

How to average the values when doing multiple selection from a filter

I have a block on my task. Can anyone please help me to solve it?
I create a Tachometer gauge, and I want to display KPI value in one month if I select a month from a filter. That's OK for single month selection. But if I select several months, I want it show me the average value of these months, actually it seems to show me total value. How can I get average value?
 
Much appreciate if you can help.
 
  
Need Help

3 Replies

  • nzkevin003's avatar
    nzkevin003
    Frequent Visitor
    7 years ago
    I have a block on my task. Can you please help me to solve it?
    I create a Tachometer gauge, and I want to display KPI value in one month if I select a month from a filter. That's OK for single month selection. But if I select several months, I want it show me the average value of these months, actually it seems to show me total value. How can I get average value?
     
    Much appreciate if you can help.
     
      
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      HI nzkevin003,

       

      If your value fields store column, you can try to modify its summary mode to 'average' to achieve this requirement.
      If not, you need to modify your measure formula to create variable summarize table, then do average calculation on this summary table.

       

      Regards,

      Xiaoxin Sheng