Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --------------------------------------------------------
- /* EMOTION BREAKDOWN
- -- Breakdown Emotion by time for specific session
- --
- --
- --
- */
- USE WAREHOUSE COMPUTE_WH;
- USE DATABASE "CUSTOMERS";
- select
- date_trunc('hour', DATEADD(MS, CUSTOMER:time, '1970-01-01')) as "Date (GMT)"
- , value:Gender.Value::STRING as GENDER
- , CUSTOMER:bodypose.session::STRING as SESSION
- , count(value) AS POPULATION
- , suM( IFF(TO_BOOLEAN(value:Smile.Value), 1, 0)) as SMILING
- , suM( IFF(value:Emotions[0].Confidence >= 75, 1, 0)) as SURPRISED
- , suM( IFF(value:Emotions[1].Confidence >= 75, 1, 0)) as SAD
- , suM( IFF(value:Emotions[2].Confidence >= 75, 1, 0)) as CALM
- , suM( IFF(value:Emotions[3].Confidence >= 75, 1, 0)) as ANGRY
- , suM( IFF(value:Emotions[4].Confidence >= 75, 1, 0)) as DISGUSTED
- , suM( IFF(value:Emotions[5].Confidence >= 75, 1, 0)) as HAPPY
- , suM( IFF(value:Emotions[6].Confidence >= 75, 1, 0)) as CONFUSED
- from FACETRACKING,
- table(flatten(input => CUSTOMER:facesdetected.FaceDetails ) )
- where CUSTOMER:bodypose.session != ''
- group by 1,2,3
- order by 3
- ;
- --------------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement