Help building an interface

Question

I am building a report and I want to build an interface that allows the users to add functionality similar to the summarize function. Ideally, users should be able to select up to 5 different columns and their respective aggregations. Then those results should added to the report as a table.

For example, if my user selects "sales":"sum", "date":"min", and "date":"max", the output should be a table like this:

ColumnAggregationResultSalesSum20412408DateMin2018-01-01DateMax2020-12-31

Do you have any idea how I can build something like this?

MicrosoftTeams-image.png

LukeL · Answer

Adam,

I like your framework , and I would take a similar approach. Attached is a branched copy of your workflow package with a simple / flexible interface: using a Text Box, we can input a series of Key:Value pairs to dynamically format the Summarize XML.

SummarizeUpdater_llight-210519.yxzp

AdamR_AYX · Answer

You could do something like the attached. I made it work for 2 fields and 2 aggregation types, but I think you could take the principle and extend it to 5 fields.

It is somewhat fiddly, but hopefully you can see how it is working.

SummarizeUpdater.yxzp

jmperafan · Answer

@danilang No, sorry if I didn't explain it correctly. We don't want a dynamic UI. In fact, how the interface looks is really just secondary, as long as it works.

We just want to use an interface to allow users to "play" with a summarize tool. In our ideal scenario, there are 5 sections in the interface where you select columns and aggregations. It should be also possible to run it if the user needs fewer aggregation than 5.

If this is not possible for whatever reason, we are fine with using a different type of interface, but in the end I just want to allow users to send input to the summarize tool.