Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
1/ I would like to display the profile of the values which is the average of all the data by dayname.These profile has to be independant from Date Selection because it has to be deduced from all the existing data.
I tried several expressions without success using something like {1} total <Date>
Is there any solution in the expression ? or script solution is unavoidable ?
Which solution do you think is the best ?
2/
I would like to display in the same chart
- the real values according to the date and
- the profile of the values which is the average of all the data by dayname.
Is it possible in QV10 ?
I attached an example
Thank you in advanced
Benjamin
Benjamin,
not sure if I got your request right, but maybe like attached?
Have a nice evening,
Stefan
edit: If you've got only a record per date, I think the expression in the second chart for your profile could be simplified to
=only({1} aggr(nodistinct avg({1}Consumption), DayName))
Benjamin,
not sure if I got your request right, but maybe like attached?
Have a nice evening,
Stefan
edit: If you've got only a record per date, I think the expression in the second chart for your profile could be simplified to
=only({1} aggr(nodistinct avg({1}Consumption), DayName))
Thanks.
It answers to my need.