Magic ETL
Magic ETL
Concat summary numbers
Hi, I'm trying to use the CONCAT function to combine two calculations into one summary number.
I want to put Sites = Count of Panels, Panels = Sum of Panels
I have done the CONCAT function but it is multiplying the numbers together it seems, I must have missed something and wasn't sure what: CONCAT(COUNT(Panels), SUM(Panels))
If someone knows it would be much appreciated
Best Answers
-
I'd try putting a space between the two just incase, like ' '.
But your logic is sound, that should have worked.
2 -
Agree with what @trafalger suggested, without any other character CONCAT will likely put the two numbers together, so 10 and 20 would be displayed as 1020. Adding the "template" of the string you want to display to the formula should work, something along the lines of:
- CONCAT('Sites = ',COUNT(Panels),', Panels = ',SUM(Panels))
2
Answers
-
I'd try putting a space between the two just incase, like ' '.
But your logic is sound, that should have worked.
2 -
Agree with what @trafalger suggested, without any other character CONCAT will likely put the two numbers together, so 10 and 20 would be displayed as 1020. Adding the "template" of the string you want to display to the formula should work, something along the lines of:
- CONCAT('Sites = ',COUNT(Panels),', Panels = ',SUM(Panels))
2 -
Thankyou both, this worked a treat!
0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 803 Beast Mode
- 79 App Studio
- 44 Variables
- 759 Automate
- 189 Apps
- 480 APIs & Domo Developer
- 73 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive