Visokio website     Downloads     Video tutorials     KnowledgeBase  
finding Average in a monthly break down - Visokio Forums
finding Average in a monthly break down
  •     rajeshbalu29 May 2, 2012 5:20AM
    Hi All,
    I am trying to find the average of the attached example excel data where it should have a formulated column which represent the average duration for that month. Please find the attached snapshot and help me on the correct funtion which can be used.

    Regards
    Rajesh B
    Attachments
    		 sample data for calculating the average.xlsx 10K
  • 5 Comments
  •     chris May 2, 2012 5:28AM
    Hi,

    Do you want to create the "Average" column inside Omniscope? So the data your reading in will contain two fields: "Duration" and "Month"?
  •     rajeshbalu29 May 2, 2012 5:34AM
    yes the Duration and month column are from the source data and I need to create Avg_Duration column in Omniscope broken down month as shown in the excel attachment.
  •     rajeshbalu29 May 2, 2012 5:36AM
    FYI... Month field is being presented as a category field.
  •     chris May 2, 2012 6:45AM
    The following formula should work:

    SUBSET_MEAN([Duration], SUBSET([Month], [Month], "="))
  •     steve May 2, 2012 7:21AM
    Equivalent shorthand:

    SUBSET_MEAN([Duration], SUBSET([Month]))
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories