chapman Member

Setup a new NetSuite2.com ODBC dataset in Domo and use this query:SELECT * FROM OA_TABLES This will give you a list of all the tables in your instance. You can also use SELECT * FROM OA_COLUMNS which will give you all the columns in all the tables.

+1. Filtering out via beast mode works but is clunky and confusing for our users having to set "Last 8 Days" to see the last 7.

This would be a godsend

@Daniel_Rumschlag you have no idea how much this comment saved me! I have a chart which looks at payroll data across a range of dates, but I want it charted with the Snapshot Date on the x axis. This shows me how the payroll from that period changed over the course of each snapshot. Domo was forcing me to use the date on…

@rco that answers it — thank you very much!

@MarkSnodgrass That's a good call — I do think that was part of my problem last night. Thank you!

Thanks @rco ! That maybe explains it; except this is a DynamoDB dataset where the field is stored as timestamp. But perhaps something is happening in the connector which is causing Domo to perform the string to date conversion as you mentioned? Here's the input dataset in question, it is definitely writing to Domo as a…

Thank you @GrantSmith — no dice. MAX(SUM(total_revenue) FIXED (FILTER DENY date))gives me the sum of all records for all time. I need the max sum by date, but not affected by the x axis. Maybe it's not possible

@david_cunningham This is a great workaround — thanks a lot!!!

@david_cunningham That can't be it — if I use City as a tooltip, it changes the granularity of the chart.

@fnukhushboo Sorry, I should have clarified — I'm asking whether there are plans to add export to embedded App Studio apps (via Domo Everywhere). There are no settings when creating the embed ID and no 3-dot menu once the app is embedded.

Are there any plans to allow the export of a table card in an app? (to CSV or XLS)

+1 for this. Would love to be able to pass a variable into a beast mode with trig functions to calculate a list of stores within X radius.

Hi @MichelleH! in both cases, I was thinking I could either do a FIXED (BY Location, Date) or SUM OVER (PARTITION BY Location, Date). I guess what I'm trying to do is aggregate on a location/date level, then filter on that without actually displaying Location and Date in the table.

+1 for this. Here's a use-case. I want to show appointments (bookings) overlaid against capacity, by week. I then want to display - on the `bookings` number only - what percentage of the total appointments are booked for that week. This is the best I can do. Would love to hide the `X% of Bookings` number for the Capacity…

@ST_-Superman-_ I love the approach -- prevents me from needing to UNION my data, which doubles my rows. There must be some dimension in my actual full dataset that is not playing nicely with the solution because, at first pass, I get SUMs of Sell-Through and TotalStartingInventory -- 7,495% and 2,326,995 respectively,…

@jaeW_at_Onyx fair point!!

FILTER ALLOW/DENY is the most useful piece of FIXED for me. What would juice up its usefulness to the next level is an ability to use static filters in the function. For example - SUM(SUM(`totalSales`) FIXED (FILTER `Client`='ABC Company')) Rather than simply allowing or denying the field filters to affect the calculation,…

@ST_-Superman-_ you're absolutely right -- logic error on my end. Thank you for the correction!!

Spent the better part of the day working on this and have a solution thanks to @MarkSnodgrass!! UNION was the answer here. I was able to pass a date field into the inventory table and combine it with the new FIXED function to get the total inventory per store, per period with filters working as expected. This returns the…

@MarkSnodgrass that's a very interesting idea - only problem is it breaks any date filtering :(

@MarkSnodgrass that was my gut reaction too but that doesn't work when I'm looking at multiple/all stores -- I get the average (55 in the example) rather than the total quantity available (110 in the example).

@RobSomers this is EXACTLY what I needed! Thank you so much! 😀