Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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()