Best Of
Re: How to erase future cumulative bar lines on line + bar chart
It looks like I was the one who answered it in the post you referenced. What you need to do is when you are testing to see if the date is for the future then you need to use a value of zero or blank. It looks like you are just placing a label of "Future" when it is a future date. That won't change the value.
If that doesn't make sense, if you can send a screenshot of Analyzer and what is in the x-axis, y-axis and series, I might be able to come up with a more exact beast mode for you.
Re: Add Maximum Items Chart Property to Pareto Chart
Great idea! In line with the Pareto Principle, I would also love to be able to dynamically limit the number of bars based on the cumulative percentage (i.e. only display named bars that make up the top 80% and group everything else into "Other").
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