Datasets

Datasets

Can I Use Calendar Card Page Filters (Ex: Last Week) on Scheduled Reports?

Member
edited March 2023 in Datasets

I have a Page in DOMO that is set with cards that show YTD Data. I have some people who are requesting I build a Weekly Scheduled Report off this Page, but they only want to see data from Last Week. I have a calendar card on the page that allows that filter, but if I use that filter and Schedule A Report it locks in the date range from when I scheduled it and doesn't update from week to week. Is this a bug or lack of functionality? Any other suggestions on how to do this w/o copying the page and changing all the cards to "Last Week"?

 

Ex: I scheduled the Report on 7/16 using the Last Week Page filter so the report i sent immediately showed data from 7/5-7/11. However, the report that was supposed to send out today, instead of showing Last Week (7/12-7/18) it still showed the 7/5-7/11 data from when i set the Page Filter.

Comments

  • @AndrewMeier , I assume your 'last week' filter is explicitly setting a date range.

     

    What if you created a column on your date dimension for isLastWeek.  Then if you set the filter 'isLastWeek= True, then as your date dimension updates the filter value is always correct?

    Jae Wilson
    Check out my 🎥 Domo Training YouTube Channel 👨‍💻

    **Say "Thanks" by clicking the ❤️ in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"

Welcome!

It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
Sign In