Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Average and Countrows formula help

I need to create a measure which shows the average number of queries from my dataset. So every row in the dataset is a query. 
So countrows should give me the total number of queries
Average should then give me the average of that count I guess, then I can apply dimensions such as date - to see average queries per day.
 
This is my attempt which does not work:
Average Queries = AVERAGE(COUNTROWS('Tech Claims Report'),'Tech Claims Report')
 
 
HELP! :-)
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI Anonymous,

     

    I'd like to suggest you take a look at library to know how these functions works:

     

    AVERAGE:Returns the average (arithmetic mean) of all the numbers in a column.

    COUNTROWS:The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

     

    You can also try to use following measure formula to group records based on category fields and get the average of these row count:

    measure =
AVERAGEX (
    SUMMARIZE (
        Table,
        [Group column1],
        [Group column2],
        [Group column2],
        "Row Count", COUNTROWS ( Table )
    ),
    [Row Count]
)

     

    Regards,
    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI Anonymous,

     

    I'd like to suggest you take a look at library to know how these functions works:

     

    AVERAGE:Returns the average (arithmetic mean) of all the numbers in a column.

    COUNTROWS:The COUNTROWS function counts the number of rows in the specified table, or in a table defined by an expression.

     

    You can also try to use following measure formula to group records based on category fields and get the average of these row count:

    measure =
AVERAGEX (
    SUMMARIZE (
        Table,
        [Group column1],
        [Group column2],
        [Group column2],
        "Row Count", COUNTROWS ( Table )
    ),
    [Row Count]
)

     

    Regards,
    Xiaoxin Sheng