kacy

HI @GrantSmith Thank you. So the issue is we want to set up an alert on the dataset because you can add filters and specifics unlike from a card. But in our data we may have duplicate rows because its different products related to 1 opportunity so there would be three rows. When I try and add the unique columns I add the…

Thank you! Thanks for the explanation as well that was very helpful!

Thanks for your help!

correct i was doing by 7, but its still not working how it should. I will keep trying. thanks!

Thanks so much! One thing that is the issue is it needs to be the same day of the week just looking back the last five weeks so if its monday, all the mondays back. I'm currently doing a lag but when I group by and sum usage it is not calculating correct so I feel like I am doing something wrong. Thanks so much for you…

 Thank you so much. I have not had a chance to look close at the video as my day got away from me.... I did quickly try adding in sum but still getting an error. Will look at the video closer tomorrow. Really appreciate it!

Thanks both! I will give this a try Thanks!