Best Of
Re: Api fails for filters
Alongside this thread and awaiting the advice of the technical adept users, reach out to Support [support.domo.com] to have them look at it as well (and escalate to Dev if need be).
amehdad
Re: Domo- Tableau conection.
And regarding Domo to Tableau, the idea was raised a few years ago [https://community.tableau.com/s/idea/0874T000000HAmTQAW/detail] but it appears no action has been taken since.
amehdad
Re: Domo- Tableau conection.
Hi @Tsharma8724, there's currently no Tableau connector in the existing Domo Appstore, although there could be an add-on connector that your customer success rep could inform you on (albeit additional cost if it exists). Otherwise, you can look through the Appstore to connect to the native data source(s) that feeds into Tableau or look at Workbench, depending on your use case.
amehdad
Re: Graph Bar split by Quarter and by month
No worries. It's because you created this as a discussion and not a question. Glad it worked for you.
Re: Nested Beast mode
You' can't have a window function inside a window function. Have you tried partitioning by the company Id and then the journey type since it sounds like you're wanting to break out your average NPS by both of those categories.
Re: Converting UTC to Central - Daylight Savings
You might be able to hack it with something like what is outlined here: https://stackoverflow.com/questions/28876683/how-to-convert-a-timestamp-from-one-timezone-to-other I'm not certain of what database you use so your syntax may be different but the logic should work.
Re: Drill Path from same Dataset returns zero value
When you're going into the drill path what are you clicking on? The drill path will add whatever you click on as the extra filter which is likely causing you to not have any results. I'm likely guessing that you're clicking on the Object_Name field for the page name and then when you're going to the card level it's filtering for cards but applying the Object_Name of the page instead of the cards as the filter so you won't have any results in your drill path. You'd need to rename a column (or create a calculated field) to pull out the name if it's a page and one when it's a card and then go based off of those values instead of Object_Name.
Re: Need Ideas/Help for Creating a Card
If you only show the order number and not the vendor or the service codes (making sure only one row per order is being shown) you could utilize some aggregates to a filter to work and then have the user click on the order number to go down a drill path to see the order details - alternatively you'd need to do your grouping and filtering in an ETL to then only display all order records which meet your criteria)
CASE WHEN MAX(CASE WHEN `Service` = 'GB' THEN 1 ELSE 0 END) = 1 AND COUNT(DISTINCT `Service`) >= 2 AND COUNT(DISTINCT `Vendor`) >= 2 THEN 'Include' ELSE 'Exclude' END
Again though, Order ID must be on your chart but you can't have Vendor or Service included in your chart otherwise the grouping won't work correctly.
Re: Graph Bar split by Quarter and by month
Hi @dylang91
You can utilize Trellis chart options on a bar chart to get something like what you're looking for, https://domohelp.domo.com/hc/en-us/articles/360043428713-Applying-DataSet-Columns-to-Your-Chart#7.