I have created two virtual columns. With the help of which I want to count the unique [team name] But my [team name] is of Enumlist types. Whose doing is single counting two names.
First virtual column expression
SPLIT(CONCATENATE([TEAM NAME]), " & ")
Second Virtual Column Expression
COUNT(UNIQUE(FILTER(“photos”[First Virtual], IN([DATE], LIST(TODAY())))))
I think the error is in the way the Expression is written of FILTER()
Examples of how to use:
Can you complete this expression and give it?
Try this expression:
COUNT(UNIQUE(SELECT(photos[First Virtual], IN([DATE], LIST(TODAY())))))
The Correct expression
SPLIT([TEAM NAME],"&")
You tell me how can I correct this expression.
This is the correct expression. For first virtual column.
SPLIT([TEAM NAME],"&")
Not working
Please help
Good day** @Sirfyaad **
Try this idea it will work
[First virtual column] expression Type of the column LIST
SPLIT(SELECT(photos[TEAM NAME],AND(CONTAINS([TEAM NAME], “&”),[DATE]=TODAY()) ),“&”)
+
SELECT(photos[TEAM NAME], AND(NOT(CONTAINS([TEAM NAME], “&”)),[DATE]=TODAY()))
[Second Virtual Column] Expression Type of the column Number
COUNT( UNIQUE([First virtual column]))
How can I use this expression in template. Without any virtual column.
By Create Bot. Event Type ( Scheduled or Data Change ) for run an action.
I have created bots. The template is also being generated. Just want to put this expression in the template. Without virtual columns.