Help with Calculation Logic for Labels In Report

Get Help
1

When looking at Charts in an entity view, the legend is hidden behind a click. I’d like to add labels to a chart, so they get displayed under each x-axis value and our users won’t need to click on the legend anymore!

I can’t figure out how to do that on this report, because I’m using the same data field (Points) to generate 3 different numbers (Points Logged, Remaining Capacity & Points Over Capacity) and because the values are always different for each team member (User), there’s no consistent way to accurately label them.

I admit that I find the reporting tool very overwhelming, so maybe there’s something obvious to more power users that I just haven’t thought of and I’d appreciate any help!

Points-Report-Fibery (1)
Points-Report-Fibery (1)2935×1681 295 KB

My calculation for “Points Logged”:

IF(
	SUMIF(
		[Points],
		[Type] == 'Point Log'
	) > SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	),
	SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	),
	SUMIF(
		[Points],
		[Type] == 'Point Log'
	)
)

My calculation for “Remaining Capacity”:

IF(
	SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	) >= SUMIF(
		[Points],
		[Type] == 'Point Log'
	),
	SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	) - SUMIF(
		[Points],
		[Type] == 'Point Log'
	),
	0
)

My calculation for “Points Over Capacity”:

IF(
	SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	) < SUMIF(
		[Points],
		[Type] == 'Point Log'
	),
	SUMIF(
		[Points],
		[Type] == 'Point Log'
	) - SUMIF(
		[Points],
		[Type] == 'Point Capacity'
	),
	0
)
2

Can’t you just copy whatever you have used in the box for Color, into the box for Label?

3

I wish it was that easy!

The values for the colors were automatically generated by Fibery and, at least from what I can tell, the formulas don’t get exposed on the front end.

I also can’t drag and drop the colors into the labels section as any attempt to click on those boxes just makes the color changer pop-up

Is there any way to reference the labels of the fields in an axis inside of other calculations?

4

Oh I see.
Then in that case, I’m not sure it’s possible.
Seems like the solution would be to make the legend visible on the embedded report.