Best Of
Re: enabling embedded App Studio app to have export functionality
@art_in_sky this was all enabled in domo in a release quite a while back. just tick allow export in the embed dialog.
Jones01
Re: Transforming an ETL
Hello - If you want to take an entire row from one dataset and add it to another then you need to Append rather than Join. If you're concerned about alterations to the existing ETL I would recommend making a copy of the ETL to test the logic and then incorporating your changes into the original ETL when you're satisfied with the results.
Re: Can you add an 'Export' Button in App?
@ArborRose How would I be able to achieve it through custom card/ App?
Re: Can you add an 'Export' Button in App?
@art_in_sky - I haven't done this for anything myself. I'd have to work through it. I would probably try to leverage the Domo Embed API. Embed the card in an iframe and add an export button to append ?export=true.
domo.get(`/v1/cards/{CARD_ID}`)
.then((card) => {
const iframe = document.createElement('iframe');
iframe.src = card.embedUrl;
iframe.width = '100%';
iframe.height = '600px';
document.getElementById('pivotCardContainer').appendChild(iframe);
document.getElementById('exportButton').addEventListener('click', () => {
window.open(`${card.embedUrl}?export=true`);
});
})
.catch((error) => {
console.error('Error embedding card:', error);
});
Or try to access the dataset using Domo's API.
document.getElementById('exportButton').addEventListener('click', async () => {
const datasetId = 'YOUR_DATASET_ID';
const response = await domo.get(`/v1/datasets/${datasetId}/data`);
const data = response.data;
// Use SheetJS or other tools to generate a file
const workbook = XLSX.utils.book_new();
const worksheet = XLSX.utils.json_to_sheet(data);
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
XLSX.writeFile(workbook, 'export.xlsx');
});
But a quick search on the web pulls some other conversations where it looks like maybe someone has already suggested a way.
Re: HTML tables filtering
On your 3 slicer cards, you can edit the dashboard and choose change interaction for each of them and de-select the other two slicer cards to keep them from reacting to each other.
Re: I got struck here can anybody help me?
Sounds interesting. Is this question coming from a school or training exercise?
- Parsing the Currency Code and Amount:
- As your screenshot shows, you can use the split column tile toseparate based on a delimiter (space or symbol that separates the code and amount) and then a formula tile to clean up or reformat the separated values.
Your screenshot shows a regular expression but I don't think Domo supports using regex pattersn in the way shown. The first formula appears to be trying to extract the numeric value followed by a currency code. The second appears to be attempting a regular expression to match three uppercase letters.
- As your screenshot shows, you can use the split column tile toseparate based on a delimiter (space or symbol that separates the code and amount) and then a formula tile to clean up or reformat the separated values.
- Calculating Average Time Between Orders:
- To find the time between orders, you can try using a Rank and Window tile to sort the orders by date.
- Then, use a date difference formula to calculate the number of days between the current and previous order for the same customer.
- Once you have those differences, aggregate them with a "Group By" tile to find the average time between orders for each customer.
- Sorry….I can't get "code block" to work in this post. I can only type. Your regular expressions might be done something like:
- REGEX(
Transaction Amount, '\d+\.\d+')
REGEX(Transaction Amount, '[A-Z]{3}')
Re: Is there a method to upload files directly to a Domo Brick?
Generally, when I create a Domo brick I use notepad ++ and create an html file to work through the problem. If it works in html, I then try putting into the Domo brick and work from there.
In this case, I can make a solution work in native html and JavaScript, but it isn't working in Domo. Paste the following into an html text file such as test.html.
<html>
<head>
<style>
</style>
</head>
<script>
document.addEventListener("DOMContentLoaded", function () {
const fileInput = document.getElementById("file-input");
const uploadButton = document.getElementById("upload-button");
const fileNameDisplay = document.getElementById("file-name");
const statusMessage = document.getElementById("status-message");
const parsedOutput = document.getElementById("parsed-output");
let uploadedFile = null;
// Update file name when a file is selected
fileInput.addEventListener("change", (event) => {
if (event.target.files.length > 0) {
uploadedFile = event.target.files[0];
fileNameDisplay.textContent = `Selected File: ${uploadedFile.name}`;
} else {
fileNameDisplay.textContent = "No file selected";
uploadedFile = null;
}
});
// Handle the upload process
uploadButton.addEventListener("click", async () => {
if (!uploadedFile) {
updateStatus("Please select a file before uploading.", "red");
return;
}
try {
// Read file content
const fileContent = await readFileContent(uploadedFile);
// Parse CSV content
const parsedData = parseCSV(fileContent);
// Display parsed data in the UI
parsedOutput.textContent = JSON.stringify(parsedData, null, 2);
updateStatus("File uploaded and processed successfully!", "green");
} catch (error) {
updateStatus(`Error: ${error.message}`, "red");
}
});
// Utility: Read file content
function readFileContent(file) {
return new Promise((resolve, reject) => {
const reader = new FileReader();
reader.onload = () => resolve(reader.result);
reader.onerror = () => reject(reader.error);
reader.readAsText(file);
});
}
// Utility: Parse CSV content
function parseCSV(content) {
const rows = content.trim().split("\n");
const headers = rows[0].split(",");
return rows.slice(1).map((row) => {
const values = row.split(",");
return headers.reduce((obj, header, index) => {
obj[header.trim()] = values[index]?.trim();
return obj;
}, {});
});
}
// Utility: Update status message
function updateStatus(message, color) {
statusMessage.textContent = message;
statusMessage.style.color = color;
}
});
</script>
<body>
<div id="file-upload-brick">
<input type="file" id="file-input" />
<button id="upload-button">Upload</button>
<p id="file-name">No file selected</p>
<p id="status-message"></p>
<pre id="parsed-output" style="background-color: #f0f0f0; padding: 10px; border: 1px solid #ccc;"></pre>
</div>
</body>
</html>
Here's a sample csv file:
Name,Age,Email,City
Alice,30,alice@example.com,New York
Bob,25,bob@example.com,Los Angeles
Charlie,35,charlie@example.com,Chicago
Diana,28,diana@example.com,Miami
The resulting output looks like this (below). But doesn't work in the Domo brick. Which doesn't solve your problem but might give you something to work from.
Re: Supress Zero Value rows in Pivot table
Assuming by row, you mean everything that will display as a row in the pivot table and not a row from your original dataset. If that assumption is correct, then the 0s will be all the values associated with what defines your rows and columns With that in mind, the BeastMode GrantSmith mentioned above would need to be a FIXED formula, since it will need to calculate across multiple rows.
FIXED reference:
I think it would be something like this, but I never get FIXED formulae right on the first try:
case when
sum(case when Value Field= 0 then 1 end) fixed(by Rows Field 1, Rows Field 2, Column Field)=
count(Value Field) fixed(by Rows Field 1, Rows Field 2, Column Field)
then 'Filter this out'
else 'Do not filter this out'
end
Re: Supress Zero Value rows in Pivot table
Since you want to ignore if an entire row is all 0s there isn't a simple built-in way to do this. You could write a beast mode which would aggregate all of the different values together for each row and then filter them out as @colemenwilson mentioned above.
Re: Initial Sandbox Setup
Hi @SarahR365
I'd recommend starting with as it outlines the Sandbox process and how you can promote connectors and share with users from your current dev instance to your new prod instance.