Forum Discussion
Duplicate Graph With Different Results
Hello,
https://i.imgur.com/cTCpNkb.png (Please use the link to see the mentioned graphs)
Could anyone explain why is graph 2 not showing the nº of "Done by" and "Checked by" by SLA? It was done the exact same way as graph 1 but, somehow, the result is different. I have tried to create a copy of the tables "Check" and "Table" and create a similar relationship with "SLA" as it was done with "People" but it did not work either.
Thank you very much for your help in advance.
3 Replies
- AllisonKennedyCommunity ChampionWhat is the purpose of the 'Check' table? This does not link currently to your main 'Table' and has no relationship to SLA since there's no SLA column in the Check table. If you remove "Count of Checked By" from the SLA graph does it behave a bit better? It should.
If you can explain the logic around how 'Checked By' is calculated, we can help you create a measure to calculate this against SLA, but with your current data model it won't work. - amitchandakSuper User
alhashmi , This SLA table value, do not have ant kind of white space or something.
Check like. In Table create a new column
New Column = related(SLA[SLA])
for all the columns you should get a value Same as what you have in SLA column of Table. If you are not getting, please correct the values either in SLA table or in Table for SLA column.