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.