topic Re: Set Analysis Result in another Set Analysis in App Development

Set Analysis Result in another Set Analysis

Anonymous — Wed, 01 Nov 2017 16:13:09 GMT

I have a First Sorted Value calculation which generates a 3 letter code for a SurveyLocation and is on the dashboard as a KPI. The First Sorted Value expression uses set analysis to generate the highest scoring SurveyLocation. I would then like to use this result in another set analysis in a table so only the comments from this top performing SurveyLocation show.

The top performing location is generated by;

FirstSortedValue(distinct

{1<Feedback_Day_Start={"<=$(=date(max({1}Feedback_Day_Start)-1))>=$(=date(max({1}Feedback_Day_Start)-7))"},

Touchpoint = {'Bag Drop'},

SurveyLocation = {"=Count({1}Score) >= 10 and len(Only({1} SurveyLocation))=3"}>}

SurveyLocation, -Aggr(Avg(

{1<Feedback_Day_Start={"<=$(=date(max({1}Feedback_Day_Start)-1))>=$(=date(max({1}Feedback_Day_Start)-7))"},

Touchpoint = {'Bag Drop'},

SurveyLocation = {"=Count({1}Score) >= 10 and len(Only({1} SurveyLocation))=3"}>}

Score), SurveyLocation))

and I would like it to appear in the SurveyLocation part of the following;

Avg({<Feedback_Day_Start={"<=$(=date(max(Feedback_Day_Start)-1))>=$(=date(max(Feedback_Day_Start)-7))"},

Touchpoint = {'Bag Drop'},

SurveyLocation = {Result Here}>}

[Insight Sentiment])

Any help would be really appreciated

Re: Set Analysis Result in another Set Analysis

sunny_talwar — Wed, 01 Nov 2017 16:19:10 GMT

How about this

Avg(

{<Feedback_Day_Start={"<=$(=date(max(Feedback_Day_Start)-1))>=$(=date(max(Feedback_Day_Start)-7))"},

Touchpoint = {'Bag Drop'},

SurveyLocation = {"$(=FirstSortedValue(distinct

{1<Feedback_Day_Start={""<=$(=date(max({1}Feedback_Day_Start)-1))>=$(=date(max({1}Feedback_Day_Start)-7))""},

Touchpoint = {'Bag Drop'},

SurveyLocation = {""=Count({1}Score) >= 10""},

SurveyLocation = {""=len(Only({1} SurveyLocation))=3""}>}

SurveyLocation, -Aggr(Avg(

{1<Feedback_Day_Start={""<=$(=date(max({1}Feedback_Day_Start)-1))>=$(=date(max({1}Feedback_Day_Start)-7))""},

Touchpoint = {'Bag Drop'},

SurveyLocation = {""=Count({1}Score) >= 10""},

SurveyLocation = {""=len(Only({1} SurveyLocation))=3""}>}

Score), SurveyLocation)))"}>}

[Insight Sentiment])

Added dollar sign expansion to my previous response here

Set Analysis Set Identifier

Re: Set Analysis Result in another Set Analysis

sunny_talwar — Wed, 01 Nov 2017 16:20:09 GMT

Or this

Avg(

{<Feedback_Day_Start={"<=$(=date(max(Feedback_Day_Start)-1))>=$(=date(max(Feedback_Day_Start)-7))"},

Touchpoint = {'Bag Drop'},

SurveyLocation = {"=SurveyLocation = FirstSortedValue(TOTAL distinct

{1<Feedback_Day_Start={""<=$(=date(max({1}Feedback_Day_Start)-1))>=$(=date(max({1}Feedback_Day_Start)-7))""},

Touchpoint = {'Bag Drop'},

SurveyLocation = {""=Count({1}Score) >= 10""},

SurveyLocation = {""=len(Only({1} SurveyLocation))=3""}>}

SurveyLocation, -Aggr(Avg(

{1<Feedback_Day_Start={""<=$(=date(max({1}Feedback_Day_Start)-1))>=$(=date(max({1}Feedback_Day_Start)-7))""},

Touchpoint = {'Bag Drop'},

SurveyLocation = {""=Count({1}Score) >= 10""},

SurveyLocation = {""=len(Only({1} SurveyLocation))=3""}>}

Score), SurveyLocation))"}>}

[Insight Sentiment])