cancel
Showing results for 
Search instead for 
Did you mean: 

How to get the total number of records in a view?

former_member186897
Contributor
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

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.