Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a bar chart which I want to run off a variable. At the moment it works, but only when a person is selected from a drop down. I want them all showing at the same time.
Dimension = Full Name
Expression = $(vOverallRisk)
Any help?
I am not good hacker 🙂 Can you please post the expression you have used "$(vOverallRisk)"
vOverallRisk = "=($(vPersonalRiskScore) +$(vFandFRiskScore) + $(vLifestyleRiskScore) + $(vWorkRiskScore)
+ $(vPersonalityRiskScore) + $(vExtrasRiskScore)) "
Hi,
I am not sure whether it will work or not but could you please try this:
In the bar chart expression, write SUM( {<[Full Name]=>}$(vOverallRisk))
Logic:
Assuming that $(vOverallRisk) is the only one value against each full name. To calculate total overallRisk for all names, we are using aggregation function sum. As $(vOverallRisk) is one value, SUM( $(vOverallRisk)) ideally should return the same value.
@Sian May be for you that make sense, But not for me because, I can't deeper how your variable holds.
BTW, Can you around to your expression as Sum(Aggr($(vOverallRisk), [Full Name]))