Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hoping someone can help.
In the attached example, how do i get it that when the past date button is selected that the table on the right reflects to just show those that fall within the criteria of the variables behind the text boxes.
Thanks.
I don't think I follow you completely here... Let's take your example and look at the image below
I selected Jeff... and for Medium Urgency and High Risk Factor... I see 3, how are you getting 8?
Also, if you see in the table... I see 3 rows... where do you see 22 rows?
What am I missing?
if you select through the drill down chart that was also attached the numbers are incorrect.
*Apologies, I mean't Medium and Critical
There are multiple issues
1) You are using set analysis in your variable to show specific value regardless of selection in Urgency and Risk Factor... to fix this... you can try this
Sum(Aggr(If(vShow = 0,
RangeSum($(vCriticalHighPD), $(vHighHighPD), $(vCriticalMediumPD), $(vHighMediumPD), $(vCriticalLowPD), $(vHighLowPD)),
If(vShow = 1,
RangeSum($(vCriticalHigh), $(vHighHigh), $(vCriticalMedium), $(vHighMedium), $(vCriticalLow), $(vHighLow)),
RangeSum($(vHighHighN14), $(vCriticalMediumN14), $(vHighMediumN14), $(vCriticalLowN14), $(vHighLowN14)))), Age, [Last Observed], [Risk Factor], Urgency))
2) One of your variable vCriticalHigh was incorrectly specified
So, basically Urgency Medium was getting double counted....
Fixed the wrongly specified variable (thank you!)
However, the if statement now does not show half of my owners in the chart....?
See if this helps
Sum(Aggr(If(vShow = 0,
RangeSum($(vCriticalHighPD), $(vHighHighPD), $(vCriticalMediumPD), $(vHighMediumPD), $(vCriticalLowPD), $(vHighLowPD)),
If(vShow = 1,
RangeSum($(vCriticalHigh), $(vHighHigh), $(vCriticalMedium), $(vHighMedium), $(vCriticalLow), $(vHighLow)),
RangeSum($(vHighHighN14), $(vCriticalMediumN14), $(vHighMediumN14), $(vCriticalLowN14), $(vHighLowN14)))), Owner, Age, [Last Observed], [Risk Factor], Urgency))
I have discovered that using the sum(agrr(
it is not showing any Low or medium results in my chart, only critical and high?
they have data in the load but just aren't showing through that expression.
Any advice?
Without seeing, nope... sorry