https://community.qlik.com/t5/App-Development/Discrepancy-of-Line-Graphs/m-p/1658196#M49289 <P>Hello!&nbsp;</P><P>We have not been able to figure this out at my workplace, so I am bringing it up to the community.&nbsp;</P><P>Scenario: I am trying to provide visuals for our customers who view our web page and then interact(engage) with our webpage.</P><P>Graph 1:&nbsp; a line graph showing two lines over time.&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Line one: Count of unique Page Views</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Line two: Count of unique Engagement with the webpage (hitting a play button, interacting with media...etc)&nbsp;</P><P>Graph 2: a line graph showing the ratio of engagement to page views. (Number of unique engagements divided by unique page views).&nbsp;</P><P>&nbsp;</P><P>The crazy part is that when I hover over both these graphs....The ratio does not = the correct answer when the "exact date" is not selected. See attached images for better description.&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Without Selecting the Date (Not working)" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/25614i8C630FE0067A061A/image-size/large?v=v2&amp;px=999" role="button" title="Rate Descrepancy.png" alt="Without Selecting the Date (Not working)" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Without Selecting the Date (Not working)</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="With selecting the date (Working)" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/25615i9303C3E94FABE7E4/image-size/large?v=v2&amp;px=999" role="button" title="Selected Date.png" alt="With selecting the date (Working)" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">With selecting the date (Working)</span></span></P> Sat, 16 Nov 2024 19:26:49 GMT Josh 2024-11-16T19:26:49Z https://community.qlik.com/t5/App-Development/Discrepancy-of-Line-Graphs/m-p/1658196#M49289 <P>Hello!&nbsp;</P><P>We have not been able to figure this out at my workplace, so I am bringing it up to the community.&nbsp;</P><P>Scenario: I am trying to provide visuals for our customers who view our web page and then interact(engage) with our webpage.</P><P>Graph 1:&nbsp; a line graph showing two lines over time.&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Line one: Count of unique Page Views</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Line two: Count of unique Engagement with the webpage (hitting a play button, interacting with media...etc)&nbsp;</P><P>Graph 2: a line graph showing the ratio of engagement to page views. (Number of unique engagements divided by unique page views).&nbsp;</P><P>&nbsp;</P><P>The crazy part is that when I hover over both these graphs....The ratio does not = the correct answer when the "exact date" is not selected. See attached images for better description.&nbsp;<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Without Selecting the Date (Not working)" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/25614i8C630FE0067A061A/image-size/large?v=v2&amp;px=999" role="button" title="Rate Descrepancy.png" alt="Without Selecting the Date (Not working)" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Without Selecting the Date (Not working)</span></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="With selecting the date (Working)" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/25615i9303C3E94FABE7E4/image-size/large?v=v2&amp;px=999" role="button" title="Selected Date.png" alt="With selecting the date (Working)" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">With selecting the date (Working)</span></span></P> Sat, 16 Nov 2024 19:26:49 GMT https://community.qlik.com/t5/App-Development/Discrepancy-of-Line-Graphs/m-p/1658196#M49289 Josh 2024-11-16T19:26:49Z https://community.qlik.com/t5/App-Development/Discrepancy-of-Line-Graphs/m-p/1658218#M49294 <P>If you are using continuous scale your ratios are averaging in the roll-up and your measure is not using an Aggr() to calculate by the date</P><P>Don't use a continuous scale or use an Aggr()</P> Mon, 16 Dec 2019 20:22:15 GMT https://community.qlik.com/t5/App-Development/Discrepancy-of-Line-Graphs/m-p/1658218#M49294 dwforest 2019-12-16T20:22:15Z