Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to show a visiting report.
The data includes:
customer name
project name
visiter
date of visit
I made a pivot table chart with the dimension:
customer name, project name, week (from date)
the expression is "count (date)" - in order to count how many visits were there at each project in each week.
Only I want to see not only the project that were visited, but the projects with no visits at that week.
How do I do that?
Any way you can share the app?
What about messing around with these options here on properties.
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.
Thank you Andrea, how ever it didnot work.
Please see a copy of the result:
You have ticked it for the Count value. Are you sure it's not based on one of the dimensions it is suppressing values?
I think you should use something as Count(DISTINCT Visiter) instead of Count(Date) as your expression in pivot table.
None of the dimntsions is clicked as suppressing values...
Any way you can share the app?
What about messing around with these options here on properties.
Yes!
I still need to "play" with it.
But it does give much more options.
Thank you
Glad to hear. You are welcome