In Slice > Row filter condition, i add this Expression:
[_RowNumber]=RANDBETWEEN(1,4300)
In Virtual Column, i add this Expression:
floor((((([_RowNumber]+0)/decimal( floor((hour(now()-date(“12/27/1900”))+0)/0.01) ))*1000000000000) -floor((([_RowNumber]+0)/decimal( floor((hour(now()-date(“12/27/1900”))+0)/0.01) ))*1000000000000))*10000)
With the method above I can display 1 card randomly and it will change every few hours.
My question is, how do I only display rows from certain [tags].
For example, I only want to display [tags] = "picnic" or "mountain".
Any idea?
Using the expression CONTAINS("[Column]", "Mountains"). Wrapping your current statement in an AND() with it.
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |