How do I format the legend in a bar graph?
I have a card with a bar graph that shows:
X Axis: Interventions
Y Axis: Average Score of each intervention (0, 1, 2, 3)
Series: Interventions
This produces an average score for each intervention. The Value Scale (Y) is set to 0, 1, 2, 3 and the Category Scale (X) lists each intervention. The legend on the right simply lists all of the categories (inteventions) and I want it to describe the Value Scale (i.e., 0= unable; 1=prompting required; 2=indpendent attempt; 3=independent success).
How do I change the legend to reflect the value scale? The legend options do not offer help.
Comments
-
Hi,
Is anyone able to help out with this request?
Thanks,0 -
Hi,
You would want the value scale in the series section.
Let me know if this works out.0 -
Thanks for the suggestion. In the analyzer - Series Calculation, I only get Count or No Aggregation since my variable ("Interventions") is nominal and changing between them does not change the legend. Unless I am looking in the wrong place?
0 -
Remove interventions and drag AVG score into the series section. That should do it.
0 -
Thanks Rahul
When I remove interventions from the series, I now get a different legend, however it just indicates the duplicated "Average" score of interventions. I see how changing the series will alter the legend, but I am trying to create a legend that describes what the scores mean (1,2,3) by which the interventions are scored.
0 -
A question is the Avg score a field or or are you averaging the score?
If its a field then you can use a beast mode like this :Case when `AVG SCORE` = 1 then 'your_text' when `AVG_SCORE` = 2 then 'your_text_for_this_score' ................... end
add this in your series section.
Let me know if you are applying the average function to the score.0 -
Ooh - getting closer.
My data source is a spreadsheet with 6 columns:
Date of Session - Modality of Treatment - Class of Intervention - Type of Intervention - Intervention - Score
There will be 15-20 interventions per session date, and each get a score that day, based on how well the client implements said intervention. In my card, I am graphing the Interventions along the X axis and `Score` for the Y axis value. The averaging comes from the drop down (pencil) on the Y axis value along the top of the chart.
I created the beast mode you suggested and can get the legend I want on the right of the graph now! But, now the bars are not showing one average score for each intervention across all sessions - since the Score field is per intervention each session and averaged within DOMO and not a field itself. Would you suggest that I Magic ETL this data set so that it produces an Average Score field and enter it that way?
0
Categories
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 463 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive