-
1. Re: How to calculate new data entry based on giving date
Deepak Rai Apr 10, 2018 11:03 AM (in response to Emrick Altidor)If you need this. Then Create a Filter Calc , Drag it to Filter Shelf and Set TRUE.
Thanks
Deepak
If it Helps, pl mark it Helpful and CORRECT to Close Thread.
-
First Bill.twbx 13.6 KB
-
-
2. Re: How to calculate new data entry based on giving date
Emrick Altidor Apr 10, 2018 11:16 AM (in response to Deepak Rai)How do I have A count the number of item instead of showing it. For example. 2/1/2018 would be 2 and 1/1/2018 would be 1 under column A@
-
3. Re: How to calculate new data entry based on giving date
Jim Van Sistine Apr 10, 2018 11:21 AM (in response to Emrick Altidor)Hi Emrick,
There seems to be a few different questions here, so I built a set of sample calcs to answer them separately.
First month of activity for a given "A"
From there, we can find the Amount in their first month of activity....
As well as the number of new "A"s that started in a given month
My workbook is attached so you can see each calculation and result. Hope this helps!
- Jim
-
New Data Entry Calcs.twbx 20.0 KB
-
-
4. Re: How to calculate new data entry based on giving date
Deepak Rai Apr 10, 2018 11:21 AM (in response to Emrick Altidor)There are few ways to do that. I have used 2. So you can select whatever you need. pl see attached
Thanks
Deepak
If this Answers, Please Mark my Reply as Helpful and CORRECT to close Thread
-
First Bill.twbx 17.0 KB
-
-
5. Re: How to calculate new data entry based on giving date
Emrick Altidor Apr 10, 2018 11:29 AM (in response to Jim Van Sistine)Thanks
-
6. Re: How to calculate new data entry based on giving date
Emrick Altidor Apr 10, 2018 11:30 AM (in response to Emrick Altidor)Thanks
-
7. Re: How to calculate new data entry based on giving date
Deepak Rai Apr 10, 2018 11:30 AM (in response to Emrick Altidor)Welcome!! If it worked, Please Close Thread.
-
8. Re: How to calculate new data entry based on giving date
Jim Van Sistine Apr 10, 2018 11:36 AM (in response to Emrick Altidor)You're welcome. Good luck!
-
9. Re: How to calculate new data entry based on giving date
Emrick Altidor Apr 10, 2018 11:39 AM (in response to Jim Van Sistine)Please re-attached. I can't seem to be able to open the file.
-
10. Re: How to calculate new data entry based on giving date
Jim Van Sistine Apr 10, 2018 11:51 AM (in response to Emrick Altidor)Which version of Tableau desktop are you using? It's built in 10.4, but I can save it back if need be.
-
11. Re: How to calculate new data entry based on giving date
Emrick Altidor Apr 10, 2018 11:50 AM (in response to Jim Van Sistine)10.1
-
12. Re: How to calculate new data entry based on giving date
Jim Van Sistine Apr 10, 2018 11:55 AM (in response to Emrick Altidor)Ok, see if this works.
I had to save it as a TWB to go back to 10.1, so I am also attaching the data spreadsheet I used.
-
DataSample.xlsx 9.4 KB
-
New Data Entry Calcs.twb 30.9 KB
-
-
13. Re: How to calculate new data entry based on giving date
Emrick Altidor Apr 10, 2018 12:02 PM (in response to Jim Van Sistine)Thanks for all the help.