How to Make a Card of Total Ratio and Recent 1 Year Ratio
Hi There,
I need DOMO Dojo expertise to help me on create 2 card using Beastmode calculation.
I have a basic data to create this 2 card:
- Month date (201706, 201707, 20178 etc)
- Product name, 2 Type: Panel & MB
- Monthly defect qty
- Cumulative sales
Idea:
The Beastmode I should create is:
- Cumulative Monthly Defect Qty
- Total Ratio
- Recent 1 Yr Cumulative sales
- Recent 1 Yr Monthly defect qty
- Recent 1 Yr Cumulative Monthly Defect Qty
- Recent 1 Yr Ratio
Card Created:
- I need to create 2 card which is only 1 product
- Combination of 2 product
- I could make this kind of trend in excel, but I'm not able to make in DOMO, due to my limitation of Beastmode calculation since I'm not a programmer student.
- Besides, I have attached the excel file for better understanding on what kind of card I would like to get.
Answers
-
0
-
@LMS ,
in the future, please be specific about what you're unable to accomplish (other than 'everything') it seems like you're asking us to provide consulting services -- which i don't think is a reasonable ask from the community site in my opinion.
you can calculate cumulative sales in your ETL or you can do it in Analyzer and avoid pre-aggregation.
to calculate cumulative sum you'll need to use window functions. you'll need your CSM to enable the feature.
you may want to partition by Product depending on your requirements
sum(sum(amount)) over ( partition by product order by date asc)
if you've never seen window functions before, here's a tutorial video. it doesn't specifically cover cumulative sum, but window functions are a set of advanced functions that you'll come across frequently.
to calculate permutations of this_Value_one_year_ago or rolling_12_months, instead of building complicated beast modes, I would add a column in ETL that counts the number of months, currentMonth_lag from the current_date() , so Feb 21 would be 0, Jan would be 1, Dec 2020 would be 2 , March 21 would be -1 April 21 would be -2.
That way you can use
case when currentMonth_Lag = 12 then ... end
etc.
Please be specific what your problem is if you have follow up questions. good luck.
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"0 -
Thank you for the suggested card building, although this is not the card i wanted, but i will try to figure out myself.
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 564 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive