Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'd like to find the average of these items I have drilled down. If you look at this data
I want to find the percentages (even though the column name is average score) here is what i have
//Count ItemID gets me 318
COUNT(ItemID) / COUNT({<ItemName = {"=ItemName"}>} ItemID)
Basically, I need to count all items that have the same parent item name
or this if you want the percentage to stay intact if you make a selection in ItemResponse
Count(ItemID)/Count(TOTAL <ItemName> {<ItemResponse>} ItemID)
May be like this
Count(ItemID)/Count(TOTAL <ItemName> ItemID)
or this if you want the percentage to stay intact if you make a selection in ItemResponse
Count(ItemID)/Count(TOTAL <ItemName> {<ItemResponse>} ItemID)
You are the man. Helping me hit a deadline in an hour. Thanks!