Hi Everyone,
I have a scenario where I have to use a Content Dynamic Block to display some data. So I have a custom table which has two fields User Type (String) and Rating (Floating Point Number).
My requirement:
1. User Type field will hold two values either "Host User" or "Guest User".
2. Rating field will have number i.e; 4 .
3. I need a selector on dashboard , where when I select "Host User" then it should show me average of all the ratings which Host User has given.
For example: there are 20 records on this custom table. Out of which 10 have value in User Type field as "Host User" and all of them have given 5 rating.
So, in dashboard it should show like : Avearge Rating Score : 5/5.
4. When I select "Guest User" then it should show me avarage of the the ratings which guest user has given.
For example: there are 20 records on this custom table. Out of which 10 have value in User Type field as "Guest User" and all of them have given 4 rating.
So, in dashboard it should show like : Avearge Rating Score : 4/5.
Can anyone guide me, how I can achieve this.
And is there a way by which I can call Single Score report into content dynamic block
Thanks in advance
