Visual for total number of records in my dataset

Question & Answer
,
1

I’m looking for a visual that just displays a count of the number of records in my dataset (the equivalent of the “card” visual in Power BI). Is there an option like this in QuickSight? Thanks.

1 Like
2

Hi,
create a new visual and select the KPI visual type. Then drag&drop one dimension (which has no NULL values, like your primary key) and drag it to the metric fieldwell of the KPI visual. Then check the aggregation, it should be “Count”.

This way you count how many rows have a value in this column.

3

Thanks so much, Thomas.

4

@thomask , I want to check how many rows in a dataset irrespective of Nulls or Blanks or anything .( Table ) . Which function is for that in Quicksight?

5

Hi,

I did not test this, but it should work.

Create a calculated field and write just ‘test’ or any string.

You should now have a column, where every row is filled with a value. So when you count this column, you should get the amount of rows in the dataset.