Forum Discussion
Count in Card and Graph visual do not match corresponding Table visual
Hi Ruehlen23
Isn't the card showing 25?
Very dificult to help you without access to your data/file.
My instinct says you are showing different data/values in the card, table and chart.
Can you supply your file please?
Regards
Phil
Hello Phil,
Thanks for taking a look. Unfortunately I can't share the file due to agency policy. The table only has 20 data points, and when I take the table visualization and convert it to the chart visualization I get the same result as shown in the picture where the chart and card visualization indicate 25 data points total instead of 20. When I compare them, for example on 10/4, the chart has a count of 2 data points whereas the table has a count of 1. Below is the data table. I appreciate any assistance, newbie here.
Regards,
Nevada
| field value | field value | Calculated column | field value | field value, null value replaced with "not rejected" | field value | field value | field value | field value |
| ID# | Temp. | Spec. Age | TestStatus | SpecimenWarningCode | Final | Collected | Date Received | ABC |
| 97 | Cold | 6 | OOS | not rejected | y | 10/21/2022 | 10/27/2022 | B |
| 99 | Cold | 6 | Done | not rejected | x | 10/21/2022 | 10/27/2022 | SP |
| 11 | Cold | 10 | OOS | not rejected | y | 10/14/2022 | 10/24/2022 | V |
| 90 | Cold | 18 | Done | not rejected | x | 9/24/2022 | 10/12/2022 | Y |
| 70 | Ambient | 2 | Done | not rejected | x | 10/4/2022 | 10/6/2022 | C |
| 53 | Cold | 6 | OOS | not rejected | y | 9/28/2022 | 10/4/2022 | ST |
| 34 | Cold | 6 | Done | not rejected | x | 9/16/2022 | 9/22/2022 | T |
| 35 | Cold | 6 | OOS | not rejected | y | 9/16/2022 | 9/22/2022 | T |
| 39 | Cold | -65741 | Done | not rejected | x | 9/20/2202 | 9/22/2022 | TP |
| 38 | Cold | -65741 | Done | not rejected | x | 9/20/2202 | 9/22/2022 | TP |
| 37 | Cold | -65741 | Done | not rejected | x | 9/20/2202 | 9/22/2022 | TP |
| 48 | Cold | 6 | Done | not rejected | x | 9/9/2022 | 9/15/2022 | L |
| 46 | Cold | 6 | Done | not rejected | x | 9/9/2022 | 9/15/2022 | L |
| 47 | Cold | 6 | OOS | not rejected | y | 9/9/2022 | 9/15/2022 | L |
| 19 | Ambient | 4 | Done | not rejected | x | 9/8/2022 | 9/12/2022 | C |
| 17 | Ambient | 4 | Done | not rejected | x | 9/8/2022 | 9/12/2022 | C |
| 16 | Ambient | 4 | Done | not rejected | x | 9/8/2022 | 9/12/2022 | C |
| 18 | Ambient | 4 | OOS | not rejected | y | 9/8/2022 | 9/12/2022 | C |
| 44 | Cold | 6 | Done | not rejected | x | 9/6/2022 | 9/12/2022 | T |
| 43 | Cold | 6 | Done | not rejected | x | 9/6/2022 | 9/12/2022 | T |