Using the summary number in beast mode
I have a data set that has invoice amount for each customer. I would need to create a card to show % invoiced for each client. % Invoiced to be calculated based on the total invoiced amount for all clients vs. the invoice amount for that client.
I have chosen the table view in the card and placed the client name and invoice amount columns. Have used the sum of invoice amount as summary number. Now i need to use the summary number in beast mode to divide the summary number with the invoice amount to get the % Invoiced.
I know how to do this in dataflow or sql query but i want to give an ability to the user to choose a date range or filter any of the clients and see the % invoiced. Is there any way that i can use the summary number in beast mode?
- 10.6K All Categories
- 13 Getting Started in the Community
- 31 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 301 Use Cases & Best Practices
- 500 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- Private Company Board