Why am I seeing blank rows in a freeform table instead of zeroes?

Forum|Forum|2 years ago
November 29, 2023
1 reply
1013 views

I've worked on a couple of Adobe implementations and with the tool itself for a number of years, and I don't recall ever seeing something like this. Instead of showing me zeroes where no data/counts exists the rows themselves are blank. What causes this? Is this normal?

Analytics

Best answer by Jennifer_Dungan

There is a setting on the column to "Interpret zero as no value"

It looks like you or someone else applied this to that column (or maybe in your User Preferences so that newly added columns are using your set preference)

You can change this display at any time to suit your needs.

Jennifer_Dungan

Accepted solution

Community Advisor and Adobe Champion

There is a setting on the column to "Interpret zero as no value"

It looks like you or someone else applied this to that column (or maybe in your User Preferences so that newly added columns are using your set preference)

You can change this display at any time to suit your needs.

F

FPW_AAAuthor

Level 2

As usual you were right Jennifer, thanks! I was using another user's report and they had that setting enabled.

M

mjdavid007

Level 3

You're welcome 🙂

This setting is really useful if you are using a line graph visualization... you don't end up with a flatline where there are zeros (also, the transition from data to no data is completely vertical as opposed to sloped)

Sorry for opening this thread again but, is it possible to hide or not show rows which have no data or 0 as value? For instance, I am using "minute" as dimension and breaking it down by page, but it is showing me every minute, despite most of them not having any data. I only want to see the Minutes which have data on them

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded