Skip to main content
Tableau Community Forums Member (Inactive) (Salesforce) ๋‹˜์ด #Id์— ์งˆ๋ฌธํ–ˆ์Šต๋‹ˆ๋‹ค

hi

attached is a table i created

the second measure  is created by using this formula : {FIXED [CODE] : AVG([LowestPricePerCarat_Calc])}

now i want to create a number i can use in a different place, that will show me the average of this column in the table -

in my case - the average of 2229, 2126,2229,2229. the problem is when i am doing an average it shows me only the average of 2229, 2126 (since there are only 2 different {codes] ).

how can i get the average of all of the numbers ?

 

thank you!

๋‹ต๋ณ€ 10๊ฐœ
  1. 2024๋…„ 11์›” 3์ผ ์˜คํ›„ 4:53

    @Oren Yannaiโ€‹ you'll just need to include your [#ID] field in the average calculation

    @Oren Yannaiโ€‹ you'll just need to include your [] field in the average calculation See attached for reference ๐Ÿ˜Š I hope this helps!Kelsie 

    See attached for reference ๐Ÿ˜Š

    I hope this helps!

    Kelsie

0/9000