Hello,
I have a data set with a column which has comma separated list of values.
e.g.
Row 1/Col1 → User1, User2, User3, User4
Row 2/Col 2 → User2
If when embedding, I pass in User value in a sessiontag, will it filter the dataset with the rows for that user ? Meaning… User 2 → Returns 2 rows, User 1 → Return 1 row etc…
Effectively session tag match is like % rather than exact match ?
Thank you.
Hello @harpar1808, I think I understand your question, but let me know if I am not understanding correctly.
It is not a % match, but rather it turns the list of options in Col1 into an array, and does an exact match based on one of the values in the array. You are correct though that user 2 would return 2 rows and everyone else returns 1. Does that make sense?
Hello @DylanM ,
Thanks you for quick response. How would it know that the column has “list” of options though?
The value in Col1 for Row 1 ==> User1, User2, User3, User4
and the value in Col1 for Row2 ==> User1.
Does it use “,” as the delimeter to know whether its “list” of options in a column value?
Thanks.
So, this is not working unfortunately. I have the below dataset:
and Session tags are enabled:
Now when I query, I pass the right value:
I expect to see more than one row in the dashboard, however its doing exact match (which is only 1 row):
Can you please advise?
Thank you.
The session tag is an exact match where you can pass multiple values. In your example, the value HP is only in 1 row. In SQL, it would be where users = ‘HP’ .
In your screenshot with data on users : [RK,DK] , [HP] , [(HP,RK,DK)], [HP,RK,DK] > these are individual values.
Here is an example where I am passing 2 values in the session tag
The dashboard displays the data for those 2 values
Kind regards,
Koushik
