Show/ display Total report results row count (more than 5000)

[samirparkar]

Hi, We want show "Total Report Result Row Count" as a measure on report. This is to help users tally the displayed total report result count to downloaded result rows while downloading large reports.

So far, custom fields using rows() or count of rows() is restricting the total to display 5000 value. We would this to be the actual number of rows that report is supposed to render. For e.g., if the report is at Product level/ revenue and if there are 6000 products, even though Looker display is restricted at 5000, we would like to the "Total Report Result Row Count" metric display 6000.

Any input on workaround for this will be really appreciated. 

Thank you!

[salehaxsid · Accepted solution]

Since Table Calculation works on the front end and displays row count based on the rows visible in a visual, its not possible to return total row count if its more than 5000.
You can try creating derived table of product and sales from visual itself by clicking "Get LookML" from the settings in explore of looker and select derive table option.
Copy the derive table code in a view, add count measure in that view and explore that view in the Model file.
You will get the total row count for Product wise sales. 

Hope it helps.