topic Re: Calculating line graph for all possible values of a dimension in App Development

Calculating line graph for all possible values of a dimension

Anonymous — Wed, 28 Jun 2017 16:27:30 GMT

I have the following measure in a line graph where my dimension is M1. However the graph only shows values when M1 is selected, and i'd like the graph to show values for every value in M1. Below the formula is a table with some example data about the values in M1.

(

Sum({$<M={$(=MFe)}>}np*fe_m)

Sum({$<M={$(=MFeAnt)}>}np*fe_m_ant)

Sum({$<M={$(=MFeAnt2)}>}np*fe_m_ant2)

)

(

Sum({$<M={$(=MFe)}>}fe_m)

Sum({$<M={$(=MFeAnt)}>}fe_m_ant)

Sum({$<M={$(=MFeAnt2)}>}fe_m_ant2)

)

M	M1	MFe	MFeAnt	MFeAnt2
1	3	3	2	1
2	3	3	2	1
3	3	3	2	1
2	4	4	3	2
3	4	4	3	2
4	4	4	3	2

Re: Calculating line graph for all possible values of a dimension

sunny_talwar — Wed, 28 Jun 2017 16:31:30 GMT

May be try using if statement instead of set analysis

(

Sum(If(M=MFe, np*fe_m))

Sum(If(M=MFeAnt, np*fe_m_ant))

Sum(If(M=MFeAnt2, np*fe_m_ant2))

)

(

Sum(If(M=MFe, fe_m))

Sum(If(M=MFeAnt, fe_m_ant))

Sum(If(M=MFeAnt2, fe_m_ant2))

)

Re: Calculating line graph for all possible values of a dimension

Anonymous — Wed, 28 Jun 2017 16:48:26 GMT

Thanks, works perfectly.