Best Of
Re: Beast mode - no aggregation
Since you're using the pivot table, it needs some way to aggregate the value. Since it's a text column, the only default is a count.
Pivot Tables can be a little particular, and sometimes will fight you on having text display. The most reliable ones I've found are something like:
CASE WHEN COUNT(`Nu`) > 10 then 'No' else 'Yes' end
Where it's not really pulling the text out of the data but is creating a text label based on an aggregation.
But depending on your data, one of these might work:
CONCAT(`Nu.`)
CASE WHEN Nu <> '' then Nu END
Re: How do I see all the visualizations available?
Assuming you are looking for all possible chart types, I love referencing @DashboardDude 's recipe book:
It helps me see and interact with all the possible chart types. I also really like this chart from MajorDomo training. It's presented as a flow chart so you can help narrow down what you are after:
Re: App Studio: Share Page as PDF
Thank you for your continued interest on this project. This project has been scheduled on our roadmap and is slated to start scoping and development in the month of March. We currently do not have an ETA on it and will have more updates once we begin development.
Re: Need Help Changing to LAST 12 Months and sorting in proper order
Thanks @DavidChurchman that worked!
Goodeman
Re: Outgoing email address
@MichelleH great thank you.
This looks very interesting and something we would definitely make use of.
I wonder if the domo support team could modify the SMTP server and from address for regular user alerts and scheduled reports.
Jones01
Re: Hide default "Choose Date" filter in App Studio
It can be done. You need to go to edit screen of app, Click anywhere in the screen, make sure you are not clicking on any component. This will open up the page setting, then click on filter options and disable the global date filter.
Re: Shopify Products and Product Variants report moving from REST API to GraphQL API
ooooo…good catch. Thanks! Here's the updated version. I can't remove the older one from this post.
Tasleema
Re: How to remove extra whitespace from the number
@Abhishek_Singh You can do this by using the SQUASH_WHITESPACE formula in the Formula tile
Re: Workflow - Email Notification
Recluz, I would encourage you to replace the "Query Dataset" step in the template (new updated template should be out soon) with the new Query Dataset shape (click on the 3 dots on the upper right of the shape, and you should see that option).
Alternatively, you can edit the "currentRow" object variable to add the children (remember, this is case sensitive and type sensitive) and then call those children directly. That will save you having to use the "Get Text From Object" steps to extract them to additional variables.