Dynamic Date Filtering with point in time data

[J P 3]

I am trying to display end of period inventory levels (day, week, or month) as part of a dynamicchart that also shows orders that came in and orders that were fulfilled and their effect on the ending inventory for that period.

Since the inventory counts are snapshots, I don't want the daily chart to then do an aggregation such assum or avg when I change the date filtering to week or month. I would like to show only the inventory value for the last day of theweek, or the last day of the month.

Currently I am only able to accomplish this by creating a separate day, week, and month chart. Is there any way to accomplish this dynamically via a single chart This is currently stumping myself and my team.

[Gaia Paolini]

Would you be able to post a sample dxp with some data It would help understand and reply to your question.

[J P 3]

Sample data added.  Rows with Data_Source=Inventory is what I'm looking to only show end of period data for when the date slider is adjusted.  Data_Source=Incoming is okay to aggregate.

[Gaia Paolini]

The data is missing inside the dxp. Can you upload again