Trying to create a comparison across two compared ...
# gd-beginnersr
Ryan Peters
02/26/2024, 9:11 PMTrying to create a comparison across two compared time periods.
Fields: Date (set to a dynamic time period; this week compare to previous period).
A MAQL measure identifying if they had done a condition (aggregated on how many calls they used our tool with and was over a certain percentage threshold).
I want to show the agents from the previous period who were in our top bucket, and what bucket they moved to if they moved. (I.e. from High -> Mid/low/no usage).
I've tried setting up two numeric metrics, and putting a filter on both columns and getting no results when there's clearly a piece. I've tried having WITHOUT PF and it's not working either
m
Michael Ullock
02/26/2024, 9:18 PMHi Ryan, can you please share with me how you have defined your metrics?
Michael Ullock
02/26/2024, 9:21 PMI can see that you also have filter set there “Was High” = 1. Can you please confirm for me what you would expect to see there, versus what you’re currently seeing? For example, would you expect to see hits/people in the “Low” & “Medium” columns?
r
Ryan Peters
02/26/2024, 9:58 PMThe result is correct.
Our metric is:
Copy code
SELECT count({label/user_id})
WHERE(
SELECT AVG({metric/analyzed_interactions_per})
BY {label/user_id}
) > 0.85Ryan Peters
02/26/2024, 9:59 PMSo this returns a 1 for any agent who has that performance result.
m
Michael Ullock
02/26/2024, 11:33 PMMy apologies for the delay in getting back to you - but would please be so kind as to provide more details on what seems to be the problem in your report. Based on the screenshot, I am not sure what is the expected results there?
r
Ryan Peters
02/27/2024, 3:59 PMThe problem is when I add a second filter to the table, of User Analyzed - High Check (which is what Was High is comparing against) = 0, it's saying "no data in your filter"
Ryan Peters
02/27/2024, 4:00 PMimage.png
m
Michael Ullock
02/27/2024, 6:30 PMHi Ryan, thanks for the additional info. It seems in this case it seems that the 2 ranking metric filters you have in place there are conflicting with each other. You have one which is looking for “=1” while the other is looking for <>1 (Does not equal). So it seems your filters and metrics are conflicting there. As the only values from your initial screenshot are the values “1"
Michael Ullock
02/27/2024, 6:35 PMPerhaps working with the IFNULL statement will help with how you work with these empty values - IFNULL statement allows you to control replacement of missing values that are returned by an expression. If a metric expression that is wrapped within an IFNULL statement ever returns a null value, the replacement number specified in the second parameter of the IFNULL function is inserted in place of the null value. More details can be found here:
https://www.gooddata.com/docs/cloud/create-metrics/maql/conditionals/ifnull/
Michael Ullock
02/27/2024, 6:37 PMPerhaps you might also find our free GoodData University courses for MAQL useful:
https://university.gooddata.com/
r
Ryan Peters
02/27/2024, 6:38 PMBut this doesn't give the functional ability to use the compare to previous period without calculating the previous period in the MAQL itself.
I'm trying to use the functionality of a previous period comparison, and compare those two values on a binary scale; was it set in the previous period and not set in the current period.
m
Michael Ullock
03/02/2024, 12:55 AMHi Ryan, I am very sorry, but I missed your last update here - Can you please let me know if you’re still having troubles with this?
r
Ryan Peters
03/05/2024, 3:07 PMI think I figured this out, yeah.