Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i'm trying to do this.
sum(game_session_count) where count(distinct sales_session_game_link_id)
Anyone know whats the correct formula?
=sum({<game_session_count = {"=count`(distinct sales_session_game_link_id) >1"}>} distinct game_session_count)
So do I create a variable for the count measure and put it inside the sum? How does it work I understand the link given but it does not help show how two measures sum and count can be in one expression
It returned a value of zero. {"=count`(distinct sales_session_game_link_id) >1"}>} what does this part mean >1?
also why is there a distinct game_session_count?