andyRowan Member

Thank you, if I created a date variable to select the proper week ending date of the timeframe how would the bestmode look to make it usable?

Yes so I will also have sales in my dataset and I will need to create calculations for available which will take my full month's sales and add them to the ending position of the month. The table will look like the below

This is the supporting dataset

I still need the totals from the full dataset so unfortunately this isn't going to work for the use case.

So my data is essentially structured like columns A-C. I want to rank by the sum of sales by style. Then I want to show the group that it's in and that group's percent to total.

Thanks so much! I did this which I am sure is wrong. I already did some manipulation to make that week ending date because for this exercise we want the week to end on sunday rather than staturday. count(id) OVER (PARTITION BY WEEK(Week Ending Date)) Getting the below

Is there a way to get data other than from a saved search? I am trying to get historical inventory position but that seems like it's only available within a report. I am using the TBA connector but it only asks for a saved search ID. From the text below it looks like I can pull more. NetSuite Connector to pull results from…

I got it working using the access token with the other connector. Thank you!

Thanks, I am still getting an error when I try to bring data in. Domo is ready, but the credentials you entered are invalid. Verify your account credentials and try again.Failed to execute import successfully.

Is this better than the basic NetSuite connector? What's the difference?