How would I get a percent change for each t value from baseline and chart it as a bar line graph
/*
Get RCI avg of all scores that aren't baseline
CASE WHEN `summary_order_rule` > 1 THEN AVG(`RCI`)
Get RCI avg of all scroes that are baseline
CASE WHEN `summary_order_rule` = 1 THEN AVG(`RCI`) END
Get %change between baseline and followup scores for each summary order
((avg_followup - avg_baseline) / avg_baseline) * 100
*/
Objective: Get a bar/line graph that shows the percent change in RCI scores for all T(x) values that exist in the dataset.
Attempt 1: The below BeastMode results in a syntax error but feels like it might be on the right path?
AVG(((CASE WHEN summary_order_rule > 1 THEN AVG(RCI) END - CASE WHEN summary_order_rule = 1 THEN AVG(RCI) END ) / CASE WHEN summary_order_rule = 1 THEN AVG(RCI) END) * 100 FIXED(BY summary_order_rule))
Attempt 2: The below BeastMode seems to be filtering out some T(2) values for some reason but not all the time? Not sure what's going on here really…
(AVG(AVG(RCI) FIXED(REMOVE CASE WHEN summary_order_rule = 1 THEN RCI END)) OVER (PARTITION BY summary_order_rule)-AVG(AVG(DISTINCT CASE WHEN summary_order_rule = 1 THEN RCI END) FIXED()))/AVG(AVG(DISTINCT CASE WHEN summary_order_rule = 1 THEN RCI END) FIXED()
Example Dataset:
Answers
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive