hi pat thanks for the help...
this is the expression after adding in your suggestion, unfortunately it does not do the trick... the calculation goes wrong instead...
=aggr(
(sum(if(Site='A', field1))
/sum(if(Site='A', field2)))*
(sum(if(Site='A', field3))
/sum(if(Site='A', field4)))*
(sum(if(Site='A', field5))
/sum(if(Site='A', field6)))
, date)
i tried using set analysis instead of aggr, it works but the graph does not adjust itself according to selections
=(sum
({$<Site ={A}>} field1)
/sum({$<Site ={A}>} field2))*
(sum({$<Site ={A}>} field3)
/sum({$<Site ={A}>} field4))*
(sum({$<Site ={A}>} field5)
/sum({$<Site ={A}>} field6))
this was the original expression,
=aggr(
if(Site='A',
(sum(field1)
/sum(field2))*
(sum(field3)
/sum(field4))*
(sum(field5)
/sum(field6))
)
, date)
oh and to add on, the date is actually part of a synthetic key that was automatically created by QV because i linked that field to the same field of a calendar table since QV's week system is different from what we want. not sure if this was part of the original problem though.
with the original expression which did not appear on the chart, if i changed the date to another date field (for e.g. lastUpdated), the line actually appears but that isn't actually the group condition we want since we want to group by the record insertion date and follow our own calendar.
