Need Report to show percent of each numeric pick list option as a percentage of total by day - how??
We use a app called SimpleSurvey. The Report request sounds fairly straight forward. We have a net promoter score of 1 - 5. Each Survey response is a value of 1 - 5 depending on their satisfaction level. So if we had 100 results today, what is the percentage of "1" responses, "2" responses, etc. Now, we need to see the trend over time of the percentage of each option by day. I am able to get this to work if only showing results for a single day:
But if I change to be "Last 30 Days" which is the request, it turns into this:
I have tried countless formula variations without success. The current formula that works for one day is:
RowCount / PARENTGROUPVAL(RowCount, GRAND_SUMMARY)
The other difficulty is that the request is for a line chart so we can see the trend over time. Each Survey Score (1-5) should have it's own line to show the percentage of each score summarized for that day. However, even when I have the report showing the correct percentages, the line chart simply does not show any results at all.
Does anyone know how to get this to work? I greatly appreciate any help I can get.
11 answers
PS.
Select PARENTGROUPVAL from the Functions menu
Then click the grouping level you want,
Then click < Insert
