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
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive