buzz_boom Contributor

Thank you. That is what I was afraid of with the beast modes. I figured the dataflow would be the cleanest way.

I should mention, that the fields will not always be three digits long. Each segment is a variable length. Thanks.

Thank you for the quick response. I have a calendar that I am matching against to smooth the data already. By smooth I mean I push Saturday and Sunday usage to the previous Friday. Could you you tell me how I should be joining the data? My first step is to join by usage table with my calendar table by the date fields. On…