ColemenWilson Coach

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

No you can only add an prefix or suffix to field name. You can change the field name, but it will change it not only in the total but also in the rest of the instances of the field name in the pivot table. Which does make sense, you want end users to understand that they are seeing the total of the same field that is in…

You can disable interactions on the dashboard so that the card is static. There is a workaround where a user could get into the expanded card details view by expanding a different card on the dashboard and then cycling through all the cards on the dashboard until they get to the one they couldn't expand. The only way to…

Happy to jump on a call to troubleshoot with you!

Writeback tiles are really useful! I would reach out to your CSM to learn more and see if they'll enable a trial for you to test it out. If you are not on consumption, there will be a cost to enable it. If you are consumption it is included but you have to request that specific writebacks are enabled in your instance, for…