Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have the same data displayed in a Table, Chart, and Card. The count in the Chart and Card are higher than the corresponding data in the table for some dates. See example highlighted in pic for 10/4 the Chart and Card count 2 but the table only has 1 entry. Any suggestions are appreciated.
Thank you.
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
Proud to be a Super User!
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 |
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |