1 Reply Latest reply: Feb 20, 2018 3:44 PM by Digvijay Singh

Data comparison

Fabiana Iglesias Feb 20, 2018 3:26 PM

I need to calculate the value of an expression exclusively for a group of data and compare them with one value; in my case, the solvency ratio for one company and compare these ratio with different sector´s companies

I´m calculating the solvency ratio where:

Solvency ratio = $(vEquity)/$(vAssets) (as a master element)

vAssets = sum({<IDAccount={'10'}>}Money)

vEquity = sum({<IDAccount={'30'}>}Money)

The groups of companies are like these:

IDGeneral	Type	IDSystem	System	IDLicense	License	IDCompany	Company	NoCompany
1111	A	1	A	1	A	1	A	1
1212	A	1	A	2	B	1	A	2
2121	B	2	B	1	A	2	B	1
2222	B	2	B	2	B	2	B	2
2223	C	2	B	2	B	2	B	3

I need to compare the Solvency ratio of my company (IDGeneral = 1111) against the groups whose IG general starts with '12', '21' and '22' in a bar graph

Re: Data comparison

Digvijay Singh Feb 20, 2018 3:44 PM (in response to Fabiana Iglesias)

You may create one synthetic Dimension in bar chart as - Valuelist('MyCompany','Startswith12','Startswith21','Startswith22')

and measure as -
Pick(Match(Valuelist('MyCompany','Startswith12','Startswith21','Startswith22'),'MyCompany','Startswith12','Startswith21','Startswith22'),
Expressionforyourcompany,Expressionfor12,Expressionfor21,Expressionfor22)

The expessions in above measure can calculate specific values for other groups like -

vAssets12 = sum({<IDGeneral={"12*"}>}Money)
vEquity12 = sum({<IDGeneral={"12*"}>}Money)
Like Show 0 Likes (0)

Actions