-
Dynamic Positional Inventory
Hi, I am looking to create a pivot table that is able to handle positional inventory dynamically. For example, if I have 3 weeks in my filtered range, I want to only show the data on the last week. I am using the below. CASE WHEN Week ending date = MAX(Week ending date) OVER () THEN SUM(ifnull(EOH Qty,0)) ELSE 0 END This…
-
Rank by Sum of Style then Compare Rank to total
Hi, I have transactional data over periods of time. Data includes dates and time periods as well as SKUs and Net sales. I want to be able to dynamically rank SKUs based on net sales to create a top 10 group and then compare that group to the total sales for the category. Trying this but I don't want the SKUs in my report…
-
Grand total of pivot table
I have a beast mode that is taking sales and dividing by number of chairs*number of locations. It looks good at the detail level but the total level is just summing rather than taking the total number of sales and dividing it by the total number of chairs. TY net sales is a sum of sales where a flag = Ty Number of stores…
-
Reset Running Total In Beast Mode
Hi, I am trying to reset the running count every time the week ending date changes. Any idea on how to do that in a beast mode as the basic setting just continues to accumulate.
-
Yext Connector Missing Data
Hi, I am using the yext connector to bring data into domo and only the google data is pulling in. We have reviews from other sources like yelp but I am only seeing google. Is that how it is designed? Does anyone else use this?
-
NetSuite Connector Setup
Hi, I am trying to get the NetSuite connector setup with domo. I am wondering if I should use the standard NetSuite Connector or the NetSuite App TBA Connector. I learned that you can't connect an admin account because of the issue with 2FA but I am also wondering where I would find the below information. There are a lot…
