Forum Discussion
Including data in visual for non-existing rows
Hi golbarg ,
Can you provide a little more information about how your data is structrued?
I am getting the desired result with 2 tables joined on User ID. How is yours different?
Sure, here goes:
| Targets |
| UserID |
| Target |
1:1
| Users |
| UserID |
| TeamID |
| Time |
| [Measure] Target = (Time - Spent(Category>Name = A)) * Target |
1:* (both directions)
| Time |
| UserID |
| ProjectID_A |
| Spent |
*:1
| Projects (A) |
| ID |
1:* (Both directions)
| Projects (B) |
| ID |
| ProjectID_A |
| CategoryID |
*:1
| Categories |
| ID |
| Name |
The Gauge Visual is on a Drill through page for a team (filtered by Users>TeamID). The Visual also has a filter applied for Categories>Name = B.
Value is the Sum of Time>Spent
Maximum value is the Sum of Users>Time
Target value is a measure
Essentially, I would like the Gauge to display Spent time in Category B, with a target that excludes time spent in Category A, and set a Maximum value of the sum of all the team's users' time.
I have another Drill through page for Users with the same Gauge Visual, and for a user where there is no Spent in the selected category, the visual shows up blank:
There is Spent time in other Categories for that user (let's call them C and D).
I was able to make it work by using a measure instead of the existing column for the Value. The measure is pretty much a sum that will return 0 if no results are met, thus forcing the rest to follow.