Comments
-
Okay, I'm getting closer. That formula isn't quite working, so what I've done is this: DATE_SUB(Date, INTERVAL 12 MONTH) I'm getting this as my filter: Which would be fine if I were just running this for March, because the way I've done Date is to simply use the first day of the month each month. However I'm trying to…
-
Thank you both! This was really helpful. I ended up using a modification: CASE WHEN RIGHT(Page Path,1) = '/' THEN Page Path ELSE CONCAT(Page Path,'/') END
-
No it's in a date format, it just looks like the date format in the formula is different than the format in my dataset. Which, I think, make the formula much simpler. I just need to tell it to take the date we selected in the card and subtract 13 months.
-
Thank you. Unfortunately I really needed an append here. I was finally able to solve it by making the Priority column the ranked value, and the date column making up the partition.
-
I'm still a little stuck. The date format is actually already calculated in the dataset to the first day of every month, and is in format like Jan 1, 2023.
-
Where, then do I use that Beast Mode? In the Date Range field?
-
@DataMaven I'm so glad a I found another person deep in the weeds with me on GA4! I was looking at recursive dataflows in another thread. How does that benefit me more than just making an ETL with a new dataset? Does it eliminate the additional rows of data?
-
This would be really, really helpful, as we like to send our clients monthly updates and they like to store them. Outlooks seems to not be consistent in its ability to add the chart images to the PDFs.