Chart with variation between days

[silvia_assuncao]

Hi!

I have a chart with values per day and asset code. And I'd like to have the variation from one day to the other for each asset code.

how can I do it?

[sunny_talwar]

Is this the goal?

Expression:

Aggr(Sum(VALUE)-Above(Sum(VALUE)), ASSET_CODE, DAY)

[silvia_assuncao]

My origninal expression has some setanalysis, how can do as you did above in this case?

(SUM({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100))

[sunny_talwar · Accepted solution]

Then try this:

Aggr(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)-Above(Sum({$<[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}>}(VALUE)/100)), ASSET_CODE, DAY)

[silvia_assuncao]

worked!

thanks