Home
Designing Analytics Reports
How to display a group title and "0" when the aggregation for that group is zero
Migrateduser
<p>I have a group that groups by team. Team 1, Team 2, etc. I have a summary at the top with a COUNTDISTINCT aggregation that counts how many games the team played. I have a filter on the data that only shows the games that were played within the past 7 days. </p>
<p> </p>
<p>Summary looks like this:</p>
<p> </p>
<p>Team 1 - 3</p>
<p>Team 3 - 2</p>
<p>Team 4 - 1</p>
<p> </p>
<p>If the team did not play a game during the past week, it doesn't show up on the report at all. I want it to be able to show up in the summary, with a '0' next to the team name. </p>
<p> </p>
<p>Any tips on how to do this? Thanks a bunch!</p>
Find more posts tagged with
Comments
There are no comments yet