Skip to Content
avatar image
Former Member

How to calculate average value?

Hi all,

I'm using Lumira 1.15. I'm doing some practices with the sample dataset BestRunCorp... I want to calculate the average value of gross margin which is grouped by lines so that I can use a line chart to show the difference between the gross margin value and average value.

How can I achieve this ?

Best regards,

Shuang

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 13, 2014 at 07:53 PM

    Hi - I haven't checked the numbers, but would this work:

    I am on 1.19 - is there a reason you are still using 1.19?  I just changed the aggregation for Gross Margin using the gear icon.


    l.png (86.6 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Tammy Powlas

      Well I think I found the reason.

      The 12 is the number of lines items (Shirt waist, Accessories ....). I mean that the total of gross margin divdide by 12.

      Thanks.