Mini charts in a table

[Roberto_Licciardello]

Hi everyone.

I'm inserting a graph into a table cell. No problem doing it, but the formula I have to use is a bit particular. The table lists the users of a service.

I have to have the month as a dimension and the average value of a list of votes received per month as a measure. But the problem is that I have to take only the smallest month and the largest month of each individual user.

the formula I thought of aggregates the vote per user, taking only the min and max, but it doesn't work. Or rather it only works if I have selected a single user, not if I have more than one in the table.

avg({<Mese={"$(=aggr(Min(Mese), User)", "$(=aggr(Max(Mese), User))"}>} Vote)

What am I doing wrong?

[BrandonFontes]

No cálculo, pelo o que penso, não seria possível porque cada resultado seria diferente e o SetAnalysis precisa ser um valor único para todos.

Talvez a solução seja criar uma flag no script informando qual o mês por usuário tem o menor e o maior voto e no SetAnalysis ficaria: Avg({<FlagMaxMin={1}>}Vote)

[Roberto_Licciardello]

Hi Brandon,

I'll give it a try. Thanks.