rdamillrda
New Member
- Joined
- Jun 10, 2019
- Messages
- 1
I have a table visualization on the canvas set up that currently looks like this:
<tbody>
</tbody>
The table is not displaying zeros. I do have "Show items with no data" checked for both Company and Place. I think there are 2 problems: 1st) For Company A/Place 3 and Company D/Place 6 the places do not appear in the source data table. The company and place are pulled from a separate data table. For some reason, the incident count is not showing zero. The 2nd problem has to do with the first two rows. The first blank row is a sum of all rows below it. It should read All Companies, All Places, and Incident Count = 5. The second row is a sum of Company A for Places 1, 2, and 3. It should read Company A Sum, All Places, and Incident Count = 2. No matter what I do I cannot get it to show. Any suggestions on this? Been working on it for far too long. Thanks.
Company | Place | Incident Count |
(Blank) | (Blank) | (Blank) |
(Blank) | (Blank) | (Blank) |
Company A | Place 1 | 1 |
Company A | Place 2 | 1 |
Company A | Place 3 | (Blank) |
Company B | Place 4 | 2 |
Company C | Place 5 | 1 |
Company D | Place 6 | (Blank) |
<tbody>
</tbody>
The table is not displaying zeros. I do have "Show items with no data" checked for both Company and Place. I think there are 2 problems: 1st) For Company A/Place 3 and Company D/Place 6 the places do not appear in the source data table. The company and place are pulled from a separate data table. For some reason, the incident count is not showing zero. The 2nd problem has to do with the first two rows. The first blank row is a sum of all rows below it. It should read All Companies, All Places, and Incident Count = 5. The second row is a sum of Company A for Places 1, 2, and 3. It should read Company A Sum, All Places, and Incident Count = 2. No matter what I do I cannot get it to show. Any suggestions on this? Been working on it for far too long. Thanks.