-
1. Re: Count No of Records within each Partition
Deepak RaiApr 19, 2017 2:28 PM (in response to mike.dale)
-
LOD for Count.twbx 27.7 KB
-
-
2. Re: Count No of Records within each Partition
Deepak RaiApr 19, 2017 2:35 PM (in response to mike.dale)
-
3. Re: Count No of Records within each Partition
mike.dale Apr 19, 2017 3:15 PM (in response to Deepak Rai)hmm...thanks but it didnt quite work.
I should have mentioned that the table above is a derived view which I derived by using other filters and calculations.
I followed your example but used INCLUDE instead of Fixed. It returned the number of rows in the datasource (xls) for each date. For example where C232 has only 1 record on the view, it would display 13, because there are 13 records with that ID and date in the xls.
-
4. Re: Count No of Records within each Partition
Deepak RaiApr 19, 2017 3:27 PM (in response to mike.dale)
Hi Mike,
so you need to provide original data and also instructions clearly what needs to be done,It was not in your Post. If you can do that, it would be easy to help.
Thanks
Deepak
-
5. Re: Count No of Records within each Partition
mike.dale Apr 19, 2017 4:20 PM (in response to Deepak Rai)Please see sheet 5 in attached workbook. The number of records are wrong.
-
LOD for Count_Mike.zip 105.8 KB
-
-
6. Re: Count No of Records within each Partition
Deepak RaiApr 19, 2017 4:29 PM (in response to mike.dale)
Hi Mike,
Somehow I cant open your twb file. pl attach twbx.
Thanks
Deepak
-
7. Re: Count No of Records within each Partition
mike.dale Apr 19, 2017 5:02 PM (in response to Deepak Rai)Sorry, please try now.
Let me know if you still having problems opening it or if you have any other questions.
Thanks.
-
LOD for Count.twbx 131.5 KB
-
-
8. Re: Count No of Records within each Partition
Daniel Vincent Apr 19, 2017 8:38 PM (in response to mike.dale)1 of 1 people found this helpfulMake sure you let us know what version you're uploading. Not everyone is using the newest version.
Based on your workbook is this what you expect to see for the results?
WINDOW_SUM(COUNTD([Car Id]))
-
9. Re: Count No of Records within each Partition
Deepak RaiApr 19, 2017 10:17 PM (in response to mike.dale)
Hi Mike,
So continuing from the LOD and using the following Calculations, you are able to get final picture as :
The Calculations are :
This would Return 1 for all Rows and then Summing up using:
Then for 2nd Part of your Question for Retaining Totals>5
Drag the Calculation 3 to Filter and Select TRUE to get:
Please See attached.
Thanks
Deepak
-
LOD for Count.twbx 135.5 KB
-
-
10. Re: Count No of Records within each Partition
Justin Larson Apr 20, 2017 10:11 AM (in response to mike.dale)1 of 1 people found this helpfulSets may be a better option here. Right click on CardId field and choose Create>Set:
Drop resulting set into filter.