Best Of
Re: Hello - I need to know how to combine data that is similar to make one
One way would be to use a beast mod calculation to create a column as a "reclass".
CASE
WHEN `Location` LIKE '%LOVES%' THEN 'LOVES'
WHEN `Location` LIKE '%TA%' THEN 'TA'
WHEN `Location` LIKE '%SPEEDWAY%' THEN 'SPEEDWAY'
ELSE 'OTHER'
END
Opps…I accidently entered before I was done.
That would create a new row for each: LOVES, TA, SPEEDWAY, OTHER. Do that in a Magic ETL or as a formula on a card. Then aggregate (eg SUM, COUNT) the column to see how many you have, calculate averages, or whatever.
Oh, and be careful with order of operation and searches like '%TA%'. Obviously you are going to have other descriptions that may have TA in them. So you may want to expand on that with case sensitive code check, or check for TA with a space following, or something to pull out the Travel Centers of America instead of something that just contains the string TA.
Re: Date filter card: default select last month dynamically?
@verytiredgirl Instead of using a specific card for your date filtering, I suggest using a filter view to default all cards to Previous Month.
To prevent the bar graph from filtering to just last month, you can uncheck the "Allow global date" box under that card's filter exceptions.
Re: downloading to PowerPoint
I'm a little confused as to which way you are populating your powerpoint. You say "download" which makes me think that you are on a dashboard in Domo and clicking the export option and choosing export as powerpoint from this menu.
Using this method, it will download in the order that the dashboard is laid out and will potentially put several cards on a slide, depending on the dashboard layout.
If you are actually using the powerpoint Domo add-in, then you should have Domo in your ribbon like this:
This option gives you the most control. I would suggest using the Search option in here and starting with a blank powerpoint presentation if you are having trouble with your company template. Select a card and add it to a slide. Once you have it added, you can copy and paste it to your company's powerpoint template.
Re: remove the option for search
Search should respect their permissions, so if they don't have access to a particular card, dashboard, or dataset, it will not show up in the search results. You will want to review what you have given them access to and then what they do in the search will only reveal what they can already see through the navigation.
Re: Renaming Report view
Looks like you are using the App Studio Report Builder, which is still in Beta.
If you click on the cog and then click on Schedule, you can change the name, which is really the Email Subject
Re: My pivot card has this red warning in the header, but when I export to excel there is no warning
If you are not seeing the warning in Excel then you can assume all the data was exported. You can refer to this KB article about limits on exporting and how it pertains to pivot tables as it counts the dataset rows and not the ultimate pivot table rows.
Re: Dynamic Chart Height
Is there any news on this feature? we have tables that have over 100 rows and then get filtered to say 5 rows. The amount of white space looks awful and makes it hard to navigate the board. Just seen this post is from 2021!
Jones01
Re: New Guy Here - What's the Point of Apps??
Just getting into Domo, and I am just now having this question. Has anyone discovered more reasons why you'd use an app over a dashboard? It seems that dashboards might be the secondary choice at some point.
Jessary
Re: Magic ETL Join visual feedback (summary of join results)
This would be a great addition to Domo and MagicETL to increase data democratization!
Re: Auto Height and Width For Cards
I came here to request something similar to the OP. Not having the ability to make our dashboards vertically responsive is compromising the design and useful of our dashboards and apps for our clients.
We have several dashboards that are meant to act as single page 'at a glance' dashboards. Regardless of the monitor they are being viewed on, the user should see all content on screen at once, without needing to scroll, and without any wasted screen space.
However, as the OP said, this not currently possible with the default layout. Cards can be sized to fit on a single monitor vertically, but when viewed on a different monitor they will often extend beyond the height of the screen, or appear 'shrunk' inside a letterbox not taking full advantage of the screen space.
An optional feature similar to how cards and bricks currently use all horizontal space available, scaling cards as necessary, would be very useful.
RichardM