Showing an Image based on A calculation

[shane]

Hello. I have a data type which is just a number field and this is really just “sentiment” So I put a 1 for angry and a 2 for neutral and a 3 for happy in each record. What I want to do is calculate the average of this field for a given date period and then show an image based on the outcome.

For example, if I want to show the sentiment for a 2 week period, I would have 14 days of numbers to add up, then divide by 14 and I get a final average. Based on that average I show an image.

Any ideas on how I would approach this?

[mguerrasio]

3 conditions on an image element to set the image source based on the following expressions

Search for sentiment’s number:average:rounded to 0 is 1

Search for sentiment’s number:average:rounded to 0 is 2

Search for sentiment’s number:average:rounded to 0 is 3

Within the search for, you can set whatever constraints you need to limit the number of records you average.

Marc

[shane]

Thank you @mguerrasio I will try that out.