Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I have table like this:
Deal ID | Tags |
---|---|
1 | tag1, tag2 |
2 | tag2 |
3 | tag2,tag3,tag4 |
4 | tag5 |
after loading, i want to see in Filter for Tags field values like:
tag1
tag2
tag3
tag4
tag5.
Not
tag1, tag2
tag2,tag3,tag4
etc.
It is real to make it?
Try like this:
LOAD [Deal ID],
SubField(Tags, ',') as Tags
FROM Source;
Try like this:
LOAD [Deal ID],
SubField(Tags, ',') as Tags
FROM Source;
Thanks! It works. But now i have next situation.
Earlier my Deals record looks like this:
Deal ID | Tags | Sum |
---|---|---|
1 | tag1, tag2 | 500 |
And after subfield(Tags,', ') it looks like this:
Deal ID | Tags | Sum |
---|---|---|
1 | tag1 | 500 |
1 | tag2 | 500 |
What kind of set analysis i need to apply for measure Income, that takes sum of all Sum fields with distinct deals ID?
May be try this:
Sum(Aggr(Only(Sum), [Deal ID]))
or
Sum(Aggr(Avg(Sum), [Deal ID]))
or
Sum(Aggr(Sum(DISTINCT Sum), [Deal ID]))