New to tableau so hopefully this is an easy solve to some wiz-kid out there
My company sells digital products but these are pre-ordered by customers before the release date.
Accounting rules mean that we cannot recognise these sales until the release date.
I need to understand how for all products released, which have different release dates, how I can defer the pre-order sales to the launch day and then recognise daily sales each day post launch.
In addition, we cut off recognising sales earlier than a calendar month end so I need to show revenues on a fiscal month basis. I presume I need to link the data to a fiscal calendar table? Can someone point in the right direction for this.