Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey, I have created a relationship between a results table and a targets table but if there isnt results for all of the channels I have targets for, the target shown is only the total target for the channels with results, for example:
If I have results table which ends up looking like:
Channel | Trasactions |
1000 | |
1000 | |
SMS | 1000 |
And a targets table which is:
Channel | Targets |
1100 | |
1000 | |
SMS | 1100 |
Phone | 500 |
And they have a relationship on Channel (bare in mind the results table will actually be per transaction), then when I make a Guage for results and targets the target shown will only be 3200 i.e. doesn't include Phone as there want any results, can anyone find a way around this as its not showing true values.
Thanks,
Harriet.
Solved! Go to Solution.
Sorry after some digging around I realised there was an error with one of the relationships.
Thanks!
H
Hey @mehaboob557 I cant quickly share it as I would need to make a completely new fake datafile instead of using the organisational data, Is there any ideas just considering the what i have explained?
Hi @H_Jones,
Please let me know is my understanding is right or not
you have results and target tables and i hope channels is the primary key.
you are having one-one relationship?
and what filters you are using?
So it is a one - many as the results table is a line per transaction and Channel is the Primary Key/used to create the relationship.
No filter used for the visual.
Sorry after some digging around I realised there was an error with one of the relationships.
Thanks!
H
User | Count |
---|---|
89 | |
75 | |
69 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |