https://community.qlik.com/t5/App-Development/Getting-the-average-over-a-range-of-dates-grouped-by-month-for/m-p/2121517#M91316 <P>I am trying to calculate a field using three different columns. I have a list of numbers that occur over the course of a few days in each month for each person in my database. I need to filter this down to having only one number from each month for each person.&nbsp;</P> <P>I thought finding the average or the mode of the number over each month for each person would be the best way, but I can't figure out how to do that. The number should be the same over each month for each person. If there is a better way please let me know. Any help is appreciated.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="This is what my table looks like currently" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116877i06CE9B1AD9649A4B/image-size/large?v=v2&amp;px=999" role="button" title="Annotation 2023-09-22 134839.png" alt="This is what my table looks like currently" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">This is what my table looks like currently</span></span></P> Fri, 22 Sep 2023 18:51:24 GMT valerieraem 2023-09-22T18:51:24Z https://community.qlik.com/t5/App-Development/Getting-the-average-over-a-range-of-dates-grouped-by-month-for/m-p/2121517#M91316 <P>I am trying to calculate a field using three different columns. I have a list of numbers that occur over the course of a few days in each month for each person in my database. I need to filter this down to having only one number from each month for each person.&nbsp;</P> <P>I thought finding the average or the mode of the number over each month for each person would be the best way, but I can't figure out how to do that. The number should be the same over each month for each person. If there is a better way please let me know. Any help is appreciated.&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="This is what my table looks like currently" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/116877i06CE9B1AD9649A4B/image-size/large?v=v2&amp;px=999" role="button" title="Annotation 2023-09-22 134839.png" alt="This is what my table looks like currently" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">This is what my table looks like currently</span></span></P> Fri, 22 Sep 2023 18:51:24 GMT https://community.qlik.com/t5/App-Development/Getting-the-average-over-a-range-of-dates-grouped-by-month-for/m-p/2121517#M91316 valerieraem 2023-09-22T18:51:24Z