Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I'm working on a dashboard in which a decline/accept percentage on damage claims is calculated.
For one date it's not that hard: sum(Toewijzing) / (sum(Toewijzing) + sum(Afwijzing))
Each record in my table has a 0 / 1 or a 1 / 0 value for these two fields.
Now I want to plot the acceptance percentage in a graph, showing this year and the past 3 years (Y-axis percentage, X-axis months). I want to give it a try using set analysis (to which I'm sort of a newbie), but I wonder how to do this, as multiple sums in one statement are not possible.
Anyone any idea how I should go about this?
sum(Toewijzing) / (sum(Toewijzing) +(Afwijzing))
shureshqv, thanks, but this is just another way of writing the same thing.. I would like to know how to translate this to a set analysis expression.
Hi,
U can use as follows
for static values as Sum({<Year={'2016','2015','2014','2013'}>}Toewijzing) [use same set analysis in rest of expressions]
for dynamic year values
set variable V_Year= year(today)-4
sum({<year={'>=$(=V_Year)'}>}Toewijzing)
Hope this helps
Regards,
SK
I'm afraid that won't do it, because I want to display the percentage of 'Toewijzing' with regard to the total of 'Toewijzing' + 'Afwijzing' (acceptance and decline).
I came up with this, which seems to work. Only thing is, it seems to be ridiculously long and I have the feeling it could be much more simple:
= 100 * (
Sum({1< [Schadecategorie] = P([Schadecategorie]), [Schadesoort] = P([Schadesoort]), [Jaar besluit]={$(vDitJaar)}>}[Toewijzing])
/
(
Sum({1< [Schadecategorie] = P([Schadecategorie]), [Schadesoort] = P([Schadesoort]), [Jaar besluit]={$(vDitJaar)}>}[Toewijzing])
+
Sum({1< [Schadecategorie] = P([Schadecategorie]), [Schadesoort] = P([Schadesoort]), [Jaar besluit]={$(vDitJaar)}>}[Afwijzing])
)
)
Hi,
Your Expression can be like this,
sum({<Year={'>=$(=Max(year)-4)'}>}Toewijzing) / (sum({<Year={'>=$(=Max(year)-4)'}>}Toewijzing) +Sum({<Year={'>=$(=Max(year)-4)'}>}Afwijzing))
Hope this helps,
Hirish
sum({$<Year={'> $(=max(Year)-3) <= $(=max(Year))'}>}Toewijzing)/(sum({$<Year={'> $(=max(Year)-3) <= $(=max(Year))'}>}Toewijzing)+sum({$<Year={'> $(=max(Year)-3) <= $(=max(Year))'}>}Afwijzing))
Thnx, pradeep,
I will try this ASAP and report back here!
Thnx, Hirish,
I will try this ASAP and report back here!