Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
Urgent help required, I am trying to achieve Required Table which the source data I have.
Please help, Thanks in Advance.
Break up the field Team name with SubField(), then on Record No perform a COUNT() while GROUPing over Team name.
Hello,
if you can modify your data in your datamodel, you can use the subfield function : subfield documentation
In your load script, is like :
Load
[Record No],
subfield([Team name],',') as Team
Resident Data;
You'll get a line for each key "Record-Team", and in the visualization, you can easily count the number of records per team.