-
1. Re: Count Based on Dates
Norbert MaijoorDec 29, 2018 1:02 AM (in response to Praveenareddy Bandi)
Hi Praveenareddy,
Not sure but find my approach as reference below based on "parameter" and stored in attached workbook version 10.5 located in the original thread.
1. P1. Begin of week Parameter
2. P2 End of week Parameter
3. D1. Display:
[P1. Begin of Week Parameter]<=[Date]
and [P2. End of Week Parameter]>=[Date]
4. Drag the required objects to the indicated location, filter D1. Display on True and show parameter controls,
Hope it helps.
Regards,
Norbert
-
begin end week nalmai_v10.5.twbx 56.4 KB
-
-
2. Re: Count Based on Dates
Praveenareddy Bandi Dec 29, 2018 6:51 AM (in response to Norbert Maijoor) -
3. Re: Count Based on Dates
Vishnu Sekhar Dec 29, 2018 9:14 AM (in response to Praveenareddy Bandi)Hi Praveen,
The data set only has 10 records between 8/4 and 8/10. That is the reason why it's showing the sum as 10. I am not sure where we have the '25' in this dataset. The parameter approach above will fine for the scenario. If you still need the ID's on the display and have the sum along with it, then use an EXCLUDE command to exclude the ID's and find the sum of the number of records.
Let me know how it helps.
Regards
Vishnu
-
4. Re: Count Based on Dates
Praveenareddy Bandi Dec 29, 2018 11:29 AM (in response to Vishnu Sekhar) -
5. Re: Count Based on Dates
Vishnu Sekhar Dec 29, 2018 2:43 PM (in response to Praveenareddy Bandi)Hi Praveen,
Thank you for clarifying the data. I have used a nested LOD for calculating the requested data. Please find the below screenshot.
Please mark the answer as 'Helpful' if it resolved the issue. It will help other users.
Regards
Vishnu
-
Nested LOD.twbx 61.6 KB
-
-
6. Re: Count Based on Dates
Praveenareddy Bandi Dec 29, 2018 4:57 PM (in response to Vishnu Sekhar)Thanks Vishnu for your response
My tableau is 10.5 version and unfortunately I cannot open your twbx in higher version.
But I'm expecting values for each week based on Begin of Week and End of Week which is dynamic and not static
Only these records in blue to display 25 (with Begin of week and End of week )
Thanks