DavidChurchman Coach

In the BeastMode, when the value rounds to a whole number, it is passing that whole number (7) to the CONCAT with ".00" to get "7.00". The ETL is maintaining that decimal (7.0), probably because of how it deals with the 'float' data type, so it gets "7.0.00". For both, I might try a different approach to get to the nearest…

I made some progress on this. I added a form to the top of my App with the fields I wanted a user to be able to control. I created a view of the form responses with only the the most recent response, and then joined the data onto that response in the view, which effectively subsets the data for those form selections. Since…

Yes! The "Range Selector" is also super finicky when working with dates, so having a purpose built date range filter with a modern UI would be great.

In general, it would be nice to be able to tie the current scale markers to a field to enable highlighting any range of interest.

I was not able to replicate this issue. With the same settings: I could see the MMM-dd format in the hover text: I don't see anything wrong with what you've shown so far. What's often the problem is the x-axis column not actually being formatted as a date, but I can tell that it is, because otherwise you would not be able…

You can add a button to the App Studio page (under controls), and then one of the actions you can configure is "Export report", and you can select the report there. Is that what you're looking for, or was there something else demoed that you saw?

Feedback: it would be nice to have a couple more options on those header/footer fields: Dynamic text (same options as on a text card would be fine) Upload a logo

Is there a way to pass the filter selections by users on the App page to the report? Ideally, I'd be able to have a user filter for the data they care about, and then use the button to "Export to PDF", which would export the nicely formatted report. It's not practical or me to create a different view/button for every…

I recommend up-voting this idea, which already has 60 votes, and maybe add a comment about why it would be helpful to you to help bump the idea back in the discussion.

If you have start/end dates for employees (common fields from HR systems), I would suggest a different approach. Let's say I have this fake data: I could join that to the calendar data set, using the 1st of each month of interest. Filter: Join: (end date is higher than the month's start date (or if it's blank, a randomly…

Weird, I can't replicated what's happening to you. I thought if you had opacity turned down and a background color, it might be interacting with that. Here's the same card/theme with a 50% opacity blue on a white background and on a red background, so you can see that the opacity turns the card purple. I thought maybe that…

Hmm, when I apply a theme, it appears the same when shown in the app and when I expand it: What does the background color look like when you view the card in the App itself? Have you looked at it using a different monitor? Screen color settings can have that kind of effect Are you seeing the color all over the card like in…

Yeah, having collapsible sections would be great. Khushboo said they were coming soon on this post a few days ago, so that's hopeful: Another implementation would be to give us more control of what users see in the Control Filters. There are a lot of votes for that here, and they say it's in the backlog (but that was a…

In the theme settings, you should be able to adjust your tables styles, which has options for background/text color. App Theme > Edit Styles > Tables > Edit Styles Then when you select your card, you should be able to select the style that you created: That style should also work on the expanded view of the card.

You can put your filters in a tabbed container at the top, with your most used filters in the first tab, and descriptions of other groups of filters they can find on the other tabs.

We don't either, but leaving it blank like this works to create an all-instance group for me:

Have you tried to match any Employee ID? I see that listed as an attribute in your screenshot.

@ckwright This KM article on how to use HTML tags to format tables/summary numbers often gets posted as a resource in this forum: https://domo-support.domo.com/s/article/360043430033?language=en_US HTML tables are often suggested as a work-around to what I think is one of the most frequent questions/requests: being able to…

Agreed. It can be very annoying to try to rearrange color-rules.

@CamBarnes Welcome, and I look forward to see where you steer the ship. @BenSchein I will strive to for empathy for you and your team, and I apologize if my comments were hurtful in any way. I have been posting more since Domopalooza because I saw in you and your team a tremendous receptiveness towards community input,…

As far as I know, they're identical. One difference in use is that in Views, you tend to be looking at the data by row, but in Analyzer, you tend to be aggregating the data. So something that looks like it's calculating correctly by row (in your view) might not calculate correctly by group (in analyzer). See this post for…

I ran into this, too. You can create a "view" of the dataset and use that view in your ETL. Open with > views explorer > save as

To add to ggenovese, you could use MagicETL group-by to sum by region, and then join the totals back onto the dataset. The result could look something like this: Order Sales$ SalesRep Region TotalbyRegion A 100 1 CA 400 B * * CA 400 C 100 3 CA 400 D * * CA 400

Back on the dataset page, you can open the dataset with "views explorer" and save a view of the dataset. That view works in MagicETL.

yes, that did it. Feedback on the product would be that you shouldn’t be able to select the editable table as an input, or there should be a more useful error when you do

@Data_Devon lol at "un-skippable ad for Claude"! @ArborRose love those ideas. Card versioning would have saved me some major headaches in the past. @BenSchein I continue to be impressed by how responsive you and your team are to this community. I am really excited to play with the new variable/slicer stuff. I use variables…

Yes! Bottom justification is so ugly

I agree! Here are a couple of related suggestions made over the years:

You asked for a conceptual explanation, so let me see if I can try one. Let's say I have 3 days of data. I'll simplify the numbers to make things more obvious. Viewed by day: Above, you can see each day's "Monthly ROI" is 3/1 =3. 30/10 =3. 300/100 =3. When I group by month, what happens? It correctly summed 3 + 3 + 3,…

What's your sort? Having a sort that competes against the way the table is being pivoted can cause this error, too. Like here's a pivot table with a sort on a column not in the pivot table: And that same pivot table with the sort removed: For your other question, are there other chart types that can do this? You could try…