Tricky Tab rendering criteria

edited February 10, 2017 in Questions
I'm trying to figure out how to render a tab based on some tricky criteria. We have a tab that normally renders for "Yesterday's Transactions", which is pretty easy since I can just see whether rows are present in a model that is defined by "Transaction date = Yesterday". What's tough is dealing with weekends. We never have transactions on Saturday or Sunday, so on Mondays I need a tab that shows the previous Friday's transactions. There doesn't seem to be an option for "Transaction date = n Days Ago" so I'm not sure how to build a model based on this. "Transaction Date = last 3 days" would work, but I'd need to be able to hide the tab for every day except Monday. Any help or ideas would be appreciated. Thanks.

Comments

  • edited August 24, 2015
    Could you do rendering on something like Transaction = Last_N_Days: 3 and Transaction != Today? Since you don't have any transactions on Saturday or Sunday, this would only capture ones from last Friday. The tricky part is if there is ever a holiday on a Monday.

    image
  • edited August 25, 2015
    One other to add to this. Transaction = Last_Weekimage
  • Matt SonesMatt Sones 💎💎💎
    edited February 10, 2017
    I think Nate is on to something. The model with those three conditions would only return results if today is Monday. So, you can set up the Monday tab to render when the model has rows. And you can set up the generic "yesterday" tab as you've already described.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!