I have an analytics that shows number of yesterdays good products. However, As you can imagine I see nothing if it is Monday. How can I change my analytic to work days so it can show me friday values if it is Monday. I have same problem with the week, I want to see Calendar Week values not 7 days rolling. How can I do this? @giladl
Hi @OzanB, this is a great question. Off the top of my head my thought is that you may need an expression that accounts that can bracket weekends. Some of my colleagues have worked through this problem before, I’ll check with them and report back.
I guess, I am missing a point here, What is a variable or a pre defined function? If this is a variable how can we select it? I will use it in a analytics in dashboard so i will not be able to query it.
If I understand your problem correctly: You have an analytic that, ideally, would give you the number of good products produced the previous work day. The problem is that your analytic just looks at the previous day, and you’d like it to account for weekends such that on Monday, you see Friday’s numbers.
Please let me know if that is not accurate.
If it is, what i’ve provided you above is an expression you can apply to the filters in your analyses for eliminating weekends. Anything with an @ in front of it is a variable, and the rest of the expression should not require configuration.
Yes this is what i am asking. Thank you for your helps.
I just want to understand one thing here, how can I input today instead of ? Since this is a dashboard I cannot use App.info current day and time?