Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Josh
Contributor II
Contributor II

Discrepancy of Line Graphs

Hello! 

We have not been able to figure this out at my workplace, so I am bringing it up to the community. 

Scenario: I am trying to provide visuals for our customers who view our web page and then interact(engage) with our webpage.

Graph 1:  a line graph showing two lines over time. 

                        Line one: Count of unique Page Views

                        Line two: Count of unique Engagement with the webpage (hitting a play button, interacting with media...etc) 

Graph 2: a line graph showing the ratio of engagement to page views. (Number of unique engagements divided by unique page views). 

 

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. Without Selecting the Date (Not working)Without Selecting the Date (Not working)With selecting the date (Working)With selecting the date (Working)

Labels (2)
1 Reply
dwforest
Specialist II
Specialist II

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

Don't use a continuous scale or use an Aggr()