Script
// Carrega a Taxas
Indices:
LOAD
Date#(@1,'DD/MM/YYYY') as DVPG, // Data a ser considerada
Num#(@2, '#.##0,00;-#.##0,00', ',', '.') as IGPD, // Valor, em pontos, da IGP-DI
Num#(@3, '#.##0,00;-#.##0,00', ',', '.') as IDTS // Valor da taxa Selic
FROM
[https://www.lellidesp.com.br/Empresas/Taxas.csv]
(txt, utf8, no labels, delimiter is ';', msq, filters(
Remove(Row, Pos(Top, 1))
));
LOAD
Date(@1, 'DD/MM/YYYY') as DVPG, // Periodo.
Num(@26*1000) as LOPP // Lucro/Prejuízo do Período.
FROM
[https://www.lellidesp.com.br/Empresas/DR/AZUL4.csv]
(txt, utf8, no labels, delimiter is ';', msq, filters(
Remove(Row, Pos(Top, 1)),
Remove(Row, RowCnd(CellValue, 5, StrCnd(null)))
));
tmpDate:
LOAD Distinct DVPG
Resident Indices;
Concatenate (tmpDate)
LOAD Distinct DVPG
Resident AZUL4;
AsOfDate:
LOAD DISTINCT DVPG as AsOfDVPG,
Date(AddYears(DVPG, -3), 'DD/MM/YYYY') as DVPG,
'3 Year Ago' as Flag
Resident tmpDate;
Concatenate (AsOfDate)
LOAD DISTINCT DVPG as AsOfDVPG,
DVPG as DVPG,
'Current' as Flag
Resident tmpDate;
DROP Table tmpDate;
Now create a chart with
Dimension
AsOfDVPG
Expressions
=Avg({<Flag = {'Current'}>} LOPP)
=Sum({<Flag = {'Current'}>} IDTS)
=Sum({<Flag = {'Current'}>} IGPD)
=Avg({<Flag = {'3 Year Ago'}>} LOPP)
