Changing filters when running a Look

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.

0 1 133
1 REPLY 1

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.