Multiple datasets in one card - Replicate from PowerBI
Hello potential helpers !
I'd like to build a card for my dashboard which shows the revenues of advertising placements against the number of sessions. What is tricky here is that the number of sessions is the same for each advertising placement. In fact,one visitor sees multple advertising placement during its session.
So, I have a dataframe with the revenues of my placements by date / language / URL etc. I appended AND joined to the dataframe, the number of sessions by date / language / URL etc.
My question is how how would you be able to create a beast mode that calculates the sum of sessions / the sum of revenues * 1000 over each placements ?
Here is what I managed to do.
The "Sessions the joined way" is very high because it is the sum of all the lines where the 204 476 023 appears in my dataframe (there are more than 3 000 000 lines in that dataframe)
What I have
Here is what I expect to get in yellow. It is a view from PowerBI which handles the multiple datasets differently.
Thank you a lot for your help. I hope you'll understand me.