This content has been marked as final.
Show 8 replies
-
Re: how to show missing data in a table
Andrea Gigliotti Nov 27, 2017 9:34 AM (in response to Ronit Kanfi)you can untick "Suppress Zero-Values" under Presentation.
In this way you can see even rows with 0 as expression, therefore all projects with no visits.
-
Re: how to show missing data in a table
Ronit Kanfi Nov 28, 2017 1:18 AM (in response to Andrea Gigliotti )-
Re: how to show missing data in a table
Ali Ahmad Nov 28, 2017 3:00 AM (in response to Ronit Kanfi)You have ticked it for the Count value. Are you sure it's not based on one of the dimensions it is suppressing values?
-
Re: how to show missing data in a table
Ronit Kanfi Nov 28, 2017 3:44 AM (in response to Ali Ahmad )None of the dimntsions is clicked as suppressing values...
-
-
Re: how to show missing data in a table
Ronit Kanfi Nov 28, 2017 4:11 AM (in response to Ali Ahmad )Yes!
I still need to "play" with it.
But it does give much more options.
Thank you
-
Re: how to show missing data in a table
Ali Ahmad Nov 28, 2017 4:12 AM (in response to Ronit Kanfi)Glad to hear. You are welcome
-
-
-
-
-
Re: how to show missing data in a table
Andrea Gigliotti Nov 28, 2017 3:28 AM (in response to Ronit Kanfi)I think you should use something as Count(DISTINCT Visiter) instead of Count(Date) as your expression in pivot table.
-
-