on 07-29-2014 10:31 PM
Hi All,
Does anyone aware how to get the total number of records in a view in Data Insight? I have observed that when we view data from the physical table it gives the total number of records but same is not available when viewing the data using a custom view.
Appreciate your help.
Regards,
Ansari MS
If you profile the user-created view (sampling rate = 1 for 100%) and hover over the blue "i" on the Workspace Home Profile Results tab after the profiling finishes, the total row count at the time of profiling will be in the summary.
The only other alternative I can think of would be to build a view on top of your view with a count(*) from the original table, but depending on how large your original view is, it is likely that might time out and not display results through the "View Data" window.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.