Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikwiz123
Creator III
Creator III

Find average per month

I have 'month' field in Dimension and 'Count(IDs)' as Measure in my table

qlikwiz123_0-1669668156760.png

 

I need to calculate average number of IDs per month. How do I do it? I thought it should be Count(IDs)/ Count (Total IDs) but it is not right.

Labels (2)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Try

count(IDs)/Count(distinct Month)

View solution in original post

1 Reply
Vegar
MVP
MVP

Try

count(IDs)/Count(distinct Month)