Grouping/Filtering

cwolman

Hello,

Our main POS system allows salespoints to be assigned to salespoint groups. Salespoint groups are a commonly used filter in our reporting outside of Domo.  One salespoint can belong to many salespoint groups (some belong to 8 or more).  Outside of Domo I would setup a salespoint group parameter, retrieve the list of salespoints that belong to the selected group and pass that list to the query as a parameter.

 

The only way I can imagine this working in Domo would be to create a row for each transaction for each salepoint group the salespoint is a member of.  A salespoint belonging to 10 salespoint groups would create 10 rows for every line item sold.  Each row can be split into 6 revenue categories which would bring my single row transaction to a total of 60 rows.

 

1,000+ salepoints, 127 salespoint groups, and millions of transaction rows each split up to an additional 6 rows...........

 

I am hoping that somebody can offer a suggestion that would not require the creation of all these rows to allow filtering.

 

Thank you in advance for your suggestions.

AS

What I've seen done in cases like this set up a series of columns for each transaction row that assign that transaction to attributes like 'Is Salesgroup 1' or 'Is Salesgroup 2'.  Then on the card you can filter to transactions that pertain to the business question.

That said, 127 groups and 6 revenue categories is a lot of extra columns.

Depending on your use, you could possibly add a single column with all the salesgroups comma delimited and the same for the revenue categories.  That's only two extra columns.