I've the following table:
In the Read Data I've used Query Fields as Advanced Setting and put the following values:
New Fileds = AVG(tariffa)
Field Alias = MediaTariffeTabellari
Then I've a Text Field that have as Value:
{var:read_media_minimi_tabellari}
And the result is: "31.993333 1 6-12 ore 21.80"
The average has been well calculated, but why it shows also the first record of the table?
Thanks.
id fascia_oraria tariffaAciont Read Data with Action Name = read_media_minimi_tabellari
===========================
1 6-12 ore 21.80
2 12-18 ore 33.02
3 18-24 ore 41.16
In the Read Data I've used Query Fields as Advanced Setting and put the following values:
New Fileds = AVG(tariffa)
Field Alias = MediaTariffeTabellari
Then I've a Text Field that have as Value:
{var:read_media_minimi_tabellari}
And the result is: "31.993333 1 6-12 ore 21.80"
The average has been well calculated, but why it shows also the first record of the table?
Thanks.