Visual table don't have all the data in dataset

Question & Answer
, , , ,
1

  • In my dataset, I have 1000 rows. One of the columns (invoice_type) has 5 distinct values. Data from database is in synch with my dataset (1000 rows).
    When I create a visual simple table, I did a simple table trying to do a distinct count using the unique key from invoice_id grouped by invoice_type.
    The simple table visual for some reason is missing 2 out of 5 invoice_type and thus the total count of the invoice is short by the actual numbers of count from those 2 missing invoice_type.
    I do not have any filter for the dataset. The preview of the dataset shows all 5 invoice_type were present.
    Can anyone let me know what’s going on? I have not seen this issue with this simple visual table before.

  • List item

2

HI @HenryQS
do you see the invoice_types within the dataset (data preview) itself?
BR

3

Yes, the invoice_types column is in the dataset, furthermore, all 5 distinct values of invoice_type is also shown in the data preview.

4

And you are sure there are no filter applied?

5

Hi @HenryQS,
It’s been awhile since we last heard from you. Wanted to check in and see if you’re still encountering your original issue or if you were able to find a work around?

If you’re still in need of help, let me know as well as any testing you’ve done since your last comment to make it work. If we do not hear back from you within the next 3 business days, I’ll go ahead and archive this topic. If you have any further questions past that, feel free to create a new topic for discussion.

Thank you!

6

Hi @HenryQS, I am marking this reply as, “Solution,” in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)