Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Make data markers on top instead of middle of the chart
Hi,
Is there a way to make data makers on the top of the bars (not in the middle ) like here : https://ibb.co/Vj5c7Sk
or maybe represent it as total on the top of the bar chart?
Thanks!
Answers
-
This is a line-bar chart. I created a Totals column, then set the line format to 0px width so it wouldn't show.
Then, I offset the line axis by 5 units, as you can see on the left-hand chart below, so the data marker for totals wasabove the other data markers. The right-hand chart is the final product, with the scales hidden.
0 -
Actually, since Line-Bar charts place the data marker above each bar,
you can simply use a null column for the line value,, as I did here:
0 -
Thanks!
1. Do you know how can I add null column to my data ? I dont have permission to change it so I need make some formula I guess ?
2. According totals that you added , in my graph I also have category separation (so I have x-axis = years, y-axis = aggregation values , and then also "values by" : some category ) so I think I cant represent totals (per year not regarding the category) ?
0 -
1. The formula for a null column is CAST(NULL AS datatype), usually with datatype=DOUBLE for numeric columns.
2. You need a separate column with a formula that sums your values by year only. SUM(values by year)
0