Create a card with variance
Hi Dojo Team,
I'm new in domo and started to explore it. I need your help while creating a crosstab chart or Table chart like below image.
I have three column which inlcude Date, Additions, Depreciation. From all these three column, I want to calcualate variance between two months like below table.
Nov,19 | Sep,19 | Variance | |
Additions during the year | 394182139.1 | 321631631.2 | 72550507.8 |
Depreciation for the year | -433876572 | -352870676 | -81005897 |
Please help me grow, learn by putting your valuable ideas and suggestion on this question.
Thanks
Suman
Comments
-
To acheive something like this I would either recommend using a beast mode calculation (calculation done on the card level where you can create a new column via a calculation.) https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode
Or you may want to look into the ETL feature where you can have the dataset run through the ETL processes, in which one of the steps is calculating the variance so that the column will be in the dataset rather than just on the card. https://knowledge.domo.com/Prepare/Magic_Transforms/ETL_DataFlows/01Creating_an_ETL_DataFlow
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive