Comments
-
Thank you John and Mark for your feedback. I think both options showed me different options to reach a similar result. Sorry John that I didn't make myself clear enough and I will try to include screenshots if I have any future requests. I work in manufacturing and throughout the month we show results by day. Each morning…
-
I want a beast mode that will filter card to month of last working day assuming a Monday to Friday work week. So for Monday March 3rd it should filter to February as the last working day was Friday Feb 28th. On Tuesday March 4th it should filter to March as last working day was Monday March 3rd. On April 1st it should…
-
Thanks for the video response. Although not what I was looking for still think I will be able to utilize for something else I am working on. Will definitely check out some of your other videos
-
Let me try and provide some more clarity. The dataset I showed is after it goes through ETL. There are two datasets feeding the ETL. The first is one that contains date, team, act hrs, plan hrs and shift. The second contains date, team, shift, station, issue and DT. I used a left join on date, team and shift. When I do…
-
Appreciate you taking the time to create a trial dataset to show how this might work. Took me a couple tries to work it out but seems to be work so far. Thank you.
-
Thank you. Tried it and it seems to be working.