Forum Discussion

ezequiel's avatar
ezequiel
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Difference in total vs raw data

I made a report that shows a total of 13.22K records but when I add a table with all the rows, and I export it I see only 12K records. I have NO filters on the table or the tile showing totals. (imag...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi ezequiel,

 

 

If you have duplicate rows in your Table visual, it shows only 1.
Try adding an index column to your table and display it in the visual to confirm, but this is probably what happens.

 

And the solution is actually that, add an index column in the Table visual (you can change the size of the column to hide it).

 

Regards.

  • ezequiel's avatar
    ezequiel
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Thanks Felipe....I added the index and I see now the 10 rows which is good, but I don't understand how this can be considered as duplicated with all the Request IDs are different. Do you know why? Thanks!