How to Make a Card of Total Ratio and Recent 1 Year Ratio
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
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
- 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.