Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
snancyiv
Contributor III
Contributor III

Average calculation by month not working

Hello, 

I'm trying to create a calculation in a table and then a chart for average of CMI by month. However, it keeps giving me the total.  I tried 3 different ways which you can see in the screenshot. I have an excel pivot of what it should be by month to compare to. Please help!

Thank you!

snancyiv_0-1679240573295.png

snancyiv_1-1679240590524.png

 

Labels (3)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

this looks like a data model issue as first glance, your YearMonth field doesn't seem to be associated to your measure field 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

3 Replies
anat
Master
Master

it helps,if possible can you share the sample data to debug the issue?

vinieme12
Champion III
Champion III

this looks like a data model issue as first glance, your YearMonth field doesn't seem to be associated to your measure field 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
snancyiv
Contributor III
Contributor III
Author

You’re right. That was the issue. Thank you!!