Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lucasx15
Contributor III
Contributor III

Calculating the average of two selected filters

Hello everybody !

I would like help in the following situation, I currently have two objects in my qvw (box and line graph) that calculate the customer satisfaction survey in our store.
It works as follows , the user selects two filters in a box and the chart plots the two selected items grouped by month/year. I used GetFieldSelections to develop this.

question avg.jpg

 


However, I would like to know how I can make it so that, when selecting two filters, the graphs also show the average of the selected items. For example:
When selecting Dinner 2 and Room Center, the average of the selected ones appears. Or when selecting Dinner 2 and Signals, display the average of the two items.

Labels (1)
0 Replies