Total Rows In Datawarehouse

Ajita

Hi Experts ,

I need some inputs on the no of rows showing in Domo DW .

It is showing 214 M rows ,I deleted unused datasets ,connectors and limited the no of rows for some datasets .

It is still showing as 214M rows ,is there anything I can do to reduce the no of rows ?

Also , if you can clarify that if I use Dataset A for Card A (rows 210K) and use View of Dataset A for Card B(rows 210k) will be counted as 420k rows in Domo ?

ColemenWilson

If this image below is where you are looking, then it is total count of stored rows. It believe it only updates daily. Domostats reports are your best bet for accurate row count.

DashboardDude

@Ajita in case you need some extra guidance

I made a video for you showing you how to check and clean up rows:

https://www.loom.com/share/fea32eeda9aa4dc5bd472ffa4ace865d?sid=49057427-1791-402b-a04b-7e4432b14834

ColemenWilson

You can get exact row counts using the Domostats datasets report. Dataset views are considered “virtual rows” that are considered stored rows from a credit consumption perspective.

Ajita

Thanks Wilson for the inputs but the question that comes to my mind is total #rows shown on Domo is it cumulative count or per day rows imported count ?

ColemenWilson

If this image below is where you are looking, then it is total count of stored rows. It believe it only updates daily. Domostats reports are your best bet for accurate row count.

Ajita

Thank you Wilson

DashboardDude

@Ajita in case you need some extra guidance

I made a video for you showing you how to check and clean up rows:

https://www.loom.com/share/fea32eeda9aa4dc5bd472ffa4ace865d?sid=49057427-1791-402b-a04b-7e4432b14834

Ajita

Thank you so much @DashboardDude ,It would surely help .