I’m working on an experience where I’d like users to answer a question via a text input asset and then provide a running tally of visitor answers via a top 5 list. I currently have the answers being added to an excel spreadsheet but I’m having issues in successfully tabulating and displaying the top answers in Intuiface. I’ve figured a couple of ways to do the tabulating within excel but am having trouble getting that data back into Intuiface due to the way that Intuiface and Excel work together (or in my case don’t work together).
First, and easiest, method would be to simply create a pivot table based on the data that is input from Intuiface. The pivot table allows me to summarize the data, get a count of unique entries and sort based on that count. The issue is that, in order to refresh the pivot table data, I either need to close and reopen the spreadsheet or include a macro to auto refresh. The macro is out as it requires saving the spreadsheet as an .xlsm (macro enable spreadsheet) which Intuiface doesn’t recognize. I’ve also tried writing a simple VB script to open the spreadsheet, save and close. This works independent of Intuiface but when I have the experience call the script it doesn’t seem to work (script seems to run, but Intuiface doesn’t reflect changes I’d expect to see if the pivot table were updated properly).
I’ve also tried to do the summarize, count and sort of the data simply with excel functions (no pivot table). Again I can make this work independent of Intuiface. The issue is that I need to use both the UNIQUE and SORT functions within excel and Intuiface doesn’t support either of these functions (per this documentation page https://support.intuiface.com/hc/en-us/articles/360007430711-Excel-Supported-Formulas-on-Windows-devices).
Has anyone else done this type of top 5 data summation work within Intuiface? Any tips or tricks that might get me what I’m looking for?