Jump to content
  • 0
Libby

Using a task to "export" aggregate, unique values

Question

Hello,

I currently have a table that has:

  • 61,000 Order records associated to a Store Location
  • 49,000 of those Orders are unique

The reason the 49,000 occasionally duplicate is because an Order can be directed to 2-3 different Store Locations.

I have built a Data Page table that:

  • Groups the order records (49,000)
  • Then has an aggregation of "Select Count (Discount [@field:Assigned_Store_Locations])
  • So it will tell me Order #ABC went to 1, 2, or 3+ Store Locations.

Exporting a download this from a Data Page is too large for Excel to open, so instead, I was thinking to create a task that  will On Demand, insert records into a show me all 49,000 Unique Orders in column A (Num_of_Orders) and the count distinct in Column B  (Hops428). 

Result would be:

  • Column A: WSA1517966827
  • Column B: 2

I have most likely built my task wrong...although it let me save, it's erroring out.

Any help would be greatly appreciated!

Task2.png

Task3.png

Task4.png

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...