Best Of

Re: Editable Data: Powering Work Lists, Annotations, Approvals hands-on question

Thank you Manasi_Panov for your active contributions to our community! We truly value your insights and the help you provide to others.

For your current question, we recommend reaching out to your Customer Success Representative. They can provide consulting services or connect you to additional resources for programming assistance tailored to your specific needs. This approach ensures you receive the most accurate and effective guidance.

Kashish_Pal

1

Re: How to show events that happened after a selected one?

Hi All,

Your ideas are so helpful! The layout of the data in the end is something to consider. I might pivot it and do it that way, but save as a separate outflow, as my current output is used across many cards and pages. @ColemenWilson I've tested your solution, and it does work! I added a 4th detail to group the results per person. In the output if there was only 1 more event then "3rd Conference" and "4th Conference" are appropriately blank.

I am checking the requirements with the stakeholders, and if many details are required in the new chart (ex. invite sent, date responded, whether they attended, etc.) I might try the pivot method.

@ggenovese my output is already at 12m rows, so am trying not to multiply the rows, but that mathematical estimation is very helpful.

Thanks again, all. Your input makes me more excited to explore Domo's capabilities : )

0RNGL4DY

1

Re: How to show events that happened after a selected one?

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:

ColemenWilson

1

Re: beast mode

If I am understanding correctly, you should be able to do the following steps using Magic ETL:

add a filter for Types IN ('Survey', 'Cutover and Test', 'EPIK','Greenix' )
add a Group By and group by Site and count distinct types
add a filter and filter on count = 3
join that back to the main dataset on site

ggenovese

1

Re: Max Slice before 'Other' Pie Chart but applies to Line Chart?

If you add a RANK() beast mode then you can filter your card on RANK < = 7

RANK() OVER (PARTITION BY `date` ORDER BY `pie value` DESC)

ggenovese

2

Re: Refresh Button Card to Refresh Domo Page in Embed

Sorry, I can't watch the video right now. But I can see your question. You should be able to include a button in your brick that triggers JavaScript to refresh

location.reload();

If you add html for the button, something like the following should work:

#refreshButton {

  margin: 10px;

  padding: 10px 20px;

  background-color: #0070d2;

  color: white;

  border: none;

  border-radius: 5px;

  font-size: 14px;

  cursor: pointer;

}


#refreshButton:hover {

  background-color: #005bb5;

}

<div id="brick-container">

  <button id="refreshButton">Refresh Page</button>

</div>

document.getElementById("refreshButton").addEventListener("click", function() {

    // Refresh the page

    location.reload();

});

ArborRose

1

Re: How to fill-down nulls from earliest instance of non-null value?

https://community-forums.domo.com/main/discussion/comment/99873#Comment_99873

Randall, thank you again for assisting me. This is an amazing and well-thought out solution. I think this is the cleanest way to achieve this result. I also want to say thank you for providing a clear explanation. Helps me understand the inner-workings that happen in the background.

alzwang99

1

Re: Show Headcount based on Date Range Selected

Hello Ankur!

A Beastmode might be an unnecessary solution here.

You can set the "Geo" (or other categorical data) on the X Axis and the "Count" of a date on your Y Axis.

You can then select whatever date you want in the date selection of the Chart itself.

This will default the date range for an untouched card.

Then, you can create a filter card to allow end users to select the date that they want to look at. This filter card does not need to be powered off a Beastmode, but rather can use the same data that is powering the output chart.

NB: If you date data is at a daily level but you want filtering ability at the month level, then a simple Beastmode can group those dates up to the month level, like so:

MONTH(`Date`)

Selecting default date range on chart:

Slicer/Filter using date field:

Data_Devon

1

Re: How to fill-down nulls from earliest instance of non-null value?

Hi @alzwang99,

You can do it with a simple Python tile and the following single line code (bold):

#Import the domomagic package into the script
from domomagic import *

#read data from inputs into a data frame
input1 = read_dataframe('your_previous_tile_name')

#write your script here
input1['ID'] = input1['ID'].map(lambda x: None if not x else x).fillna(method='ffill')

#write a data frame so it's available to the next action
write_dataframe(input1)

Manasi_Panov

1