How to calculate MOD for last 7 days Quicksight

Hi,

I have total time column to complete 1 item. I’m trying to calculate Last 7days MOD.
time need to consider between >=35 to <=90.

Hi @rmanik - Welcome to AWS Quick Sight community and thanks for posting the question. Can you please share sample data and expected output so that community can guide you the right approach and solution.

Regards - Sanjeeb

Hi @rmanik

Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.