App Development

[Josh]

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)With selecting the date (Working)

[dwforest]

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()