I got a little further on this...
When I have the view set to weeks, i get all the data added together for that week. So if the minimum qty for inventory is supposed to be 400 units, i would get 2800 units for the week. I can have the week show a better reflection of min levels by doing sum(qty)/7 but that skews up the results for the current week.
I tried doing
if [Weeks] < datepart('week',today()) then
(Qty) / 7)
(Qty)/(datediff('day', date("1/1/2012"), today()) - ((datepart('week',today()) - 1) * 7) + 1) end
But i have the following problems:
1. I cant mix non-aggregate and aggregate functions // is there a way to divide an aggregate number by just a #??
2. (datediff('day', date("1/1/2012"), today()) - ((datepart('week',today()) - 1) * 7) + 1) needs to change, it doesnt work.
Ideally, i would want to divide the aggregate by the 7 or the number of days this week but cant mix non and aggregate function.. any advice will be rewarded with good Karma.
Did you ever get this figured out?
Not really because i had to postpone to do some other tableau work (thankfully it is easier).
I think i have a problem because our database only has real time inventory levels. so I cant really see inventory levels on the 3rd of june because we do not capture that data. The 3rd of june would show all inventory that we have currently that was produced up to june third but would reflect any products that went out after june third. im not sure if im making sense.
At least thats what i think haha..