1 of 1 people found this helpful
since you did not include a twbx workbook I am not able to give you specific results but conceptually
First create a parameter - type string - fields - day, month, year
Then determine the number of periods for the denominator as the datediff(parameter value, start date, end date)
Then divide the value by the total number of periods
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you for your response, I will try to do as you wrote and distribute Quantity by day in the given period.
I will add a Tableau File with the sample data.
Thank you for your help
Companies Quantity.twbx 14.8 KB