I have been running through the API explorer in my instance, and have gotten some things to run with the python SDK, but I am stumped when looking for this:
I have a look that is filtered to return data based on ‘activity_date within the last 7 complete days.’ How do I run that look with a different value for that filter? (e.g. last 14 days)
I assume that I could return the SQL from the base look, and parse out and replace the date filtering in the where clause, but that seems, like a lot of hoops to jump through. I didn’t know if I was missing something more obvious.
I did search the discourse for the answer to this before posting. (I promise!)
However, this is a long standing feature request here and you can find a pretty thorough explanation of how to solve this problem (similar to what I described above) in the answer here which was about doing this for a PowerPoint deck.