ColemenWilson Coach

Yes to all of your questions! You can either use Filter Views, Filter Cards on your page, or filters on the cards themselves (Quick Filters). 1.Page Filters/Filter Views: 2.Filter Cards: 3.Quick Filters:

What you've shown in your screenshot are "Filter Views" they are bit different. In my screenshot I added filter cards (cards whose only purpose is to filter other content) to the dashboard. Here is a KB article explaining filter views: To use filter cards, what I showed in my screenshot, you need to create a filter card in…

You can create multiple filter cards on your dashboard, as shown in my screenshot above. Just create a new filter card and save it to the dashboard. When you use the filter on the dashboard it will apply to all cards on the dashboard that have data powering them with that field name.

This is not possible within a card, however you have some options: 1. Create a dashboard and add drop down filters above your table card on the dashboard 2. Add quick filters to the table card to filter the data, these will be either single select, multi-select or match values filters - Not a dropdown. Dashboard with…

This is a fantastic idea!!!

No problem! It's called "Order Tile" for Magic ETL.

Would users using the date range and graph by options suffice? Without creating any variables, users can select if they want YoY, QoQ, MoM, WoW, DoD and the date range to compare.

There is a new tile in Magic ETL that is currently in Beta that would allow for this and make it MUCH easier. You can reach out to your CSM to see if you can join the beta for it. Otherwise, you'll have to use a SQL dataflow and do the following: 1. Create a table in a MYSQL dataflow: SELECT Account ID, CASE WHEN…

Yes you can accomplish this using Magic ETL. Step 1: Split out your input data into two groups: Starts and Ends. Use two formula tiles. Formula tile #1 (Starts) will look like this: Formula tile #2 (Ends) will look like this: Step 2: Append these groups together using the Append Rows tile: Step 3: Use a filter tile to…

Use CASE WHEN: CASE WHEN Last_Update >= NOW() - INTERVAL 4 HOUR THEN 1 ELSE 0 END

You can use the Dynamic Unpivot tile in Magic ETL: Results:

I understand now, thank you! Yes you will want to do what @ggenovese recommended.

I've re-read this like 10 times and can't figure out exactly what you are trying to do. Could you share once again slightly differently? Or maybe show two excel samples: what the data currently looks and how you would like the data to look with the beastmode?

You could use a lead function to get all the conferences attended on the same row in an ETL. 1. Use Rank and Window tile to create lead functions 2. Filter to only rows where Conference Attended = 'A' Final output:

This is an SSO issue. How have you configured SSO for your instance?

@DavidChurchman looks like you are in a dataset view, not the data center. @nickcorona things look normal for me: I would recommend submitting a case to Domo Support.

The stakes are high. I'm trying to win some Domo branded keychains.

@DashboardDude option 1 seems like the way to go for a couple of reasons: 1. Least complexity/effort 2. Least credit implications 3. Was the idea I suggested so I would get the accepted answer :D

Also, if it makes you feel any better, I once deleted a page that had 27 highly used subpages that got deleted with it. It was the worst day of my career.

Oh I remember it was @Tasleema who said this could be done.

I was told this is possible by my CSM or AE I can't remember which one. But it would require working with Domo to enable for the instance/dataset.

@helpme12345 I did join but had trouble joining the meeting in Zoom so I was 5 min late. I have a lot of availability this week if you want to reschedule!

More notebook card bugs: Trying to change the color on the text doesn't apply. Trying to highlight and delete the text does not delete it. Then randomly the page blanks out.

I recorded an example of one issue. In the recording I type text and then hit enter to move to the next line below but instead it deletes the text, then just blanks out the browser window.

Hi @helpme12345 , I am still in the meeting if you can rejoin. I had trouble logging in, apologies for being a few minutes late. If you need to reschedule please let me know!

@MParr At our company we have a process to archive pages rather than delete them. 1. Create a page called something like "Archived Pages" 2. Move the page you want to archive as a subpage of "Archived Pages" 3. Remove sharing for everyone but you (and maybe your team as well) 4. Add [Archived] or [ARC] as a prefix to the…

I approached this using Magic ETL, and here is how I did it: 1. Create a Lead and Lag function to get the previous End Date and the upcoming Start Date. 2. Create a formula to flag when there is overlap. (also by creating this I noticed that your data in the excel screenshot for overlap appears wrong. For Customer ABC…

Yes you can hide the wrench: 1. Edit the dashboard 2. Go to the card you want to hide the wrench for 3. Click "Edit Content" 4. Click "Appearance" 5. Deselect "Card Options Button" 6. Save and exit

Hi @Adrianne Spiker this idea already exists, you can upvote it here:

You could submit the functionality you are looking for as an idea in the