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.
Best Answer
-
assuming you use the APPEND model:
it sounds like "for each row, calculate sum of revenue divided by the sum of all sessions."
sum(revenue) / sum(sum(sessions)) over ()
you'll need to ask your CSM to enable aggregate functions in beast modes.
Here's a tutorial video with an example: https://www.youtube.com/watch?v=ZPf41Fjn1H8&t=939s
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
assuming you use the APPEND model:
it sounds like "for each row, calculate sum of revenue divided by the sum of all sessions."
sum(revenue) / sum(sum(sessions)) over ()
you'll need to ask your CSM to enable aggregate functions in beast modes.
Here's a tutorial video with an example: https://www.youtube.com/watch?v=ZPf41Fjn1H8&t=939s
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Hi @jaeW , Thanks for answering this one!
@user061469 To complete what Jae has said, I would point out that a lot of the aggregated functions may already be working on your instance without the need for you to reach your CSM.
You would need to reach to your CSM if you want to use these aggregate functions within your filter conditions as this is a feature request.
FYI, some aggregate functions are supported and will run without problem in Domo, such as SUM() and RANK() but some are not supported and may not work well or with all chart options (i.e. MIN(), MAX(), NTILE(), etc...)
I hoe that clarified it!
1 -
Thank you Jae,
Your video also helped me out !
Have a great day !
1
Categories
- 10.5K All Categories
- 4 Connect
- 914 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 170 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive