Best Of
Re: How to create DoD variance formula
Does your dataset always have data for each day? In other words, if on a particular day, the value is zero, will it show up as a row with the date, and a value of zero, or is the row for that date simply not in the dataset?
If the former, here are some details on how you could achieve this. Note, this also assumes that the data is already aggregated up by day and group. If not, you'll need to do that aggregation first. If you don't have data for each day, and you want to compare to the last 3 days, and not the last 3 values, you'll need to combine your data to a date dimensions table.
For instance, say you have this example dataset.
First thing is to use the Rank & Window Tile to create a lag function
From there we can create a function called "alert_triggered" that will evaluate if the value changed by > 90% or is equal to 0. We set the output as either 1 or 0 (true or false). I assumed since you said variance that you meant a 90% swing in either direction, which is why it's wrapped in an ABS() function.
case
when ABS((value-3_days_ago)/3_days_ago) > .9
or value = 0
then 1
else 0
end
From there you can use the alert_triggered column in your Summary Number. You would then set up your alert to trigger when Summary Number > 0
Re: Multi-Line Chart with a "Stacked" Y-Axis?
@GarethR - there are 2 possible options.
Domo has something called a flex table (see below).
You could also use a faceted bar chart if your output doesn't have to be a line.
Re: Having both horizontal and verticle marker on a Line Chart
I don't know about the default line chart. But I can do it in a brick.
<html> <head> <script src="https://cdn.jsdelivr.net/npm/chart.js"></script> <script src="https://cdn.jsdelivr.net/npm/chartjs-plugin-annotation"></script> </head> <body> <canvas id="myChart"></canvas> </body> </html>
const ctx = document.getElementById('myChart').getContext('2d');
const myChart = new Chart(ctx, {
type: 'line',
data: {
labels: ['January', 'February', 'March', 'April', 'May', 'June', 'July'],
datasets: [{
label: 'Dataset',
data: [65, 59, 80, 81, 56, 55, 40],
borderColor: 'rgba(75, 192, 192, 1)',
borderWidth: 1,
fill: false
}]
},
options: {
scales: {
x: {
beginAtZero: true
},
y: {
beginAtZero: true
}
},
plugins: {
annotation: {
annotations: {
verticalLine: {
type: 'line',
xMin: 3, // Position on the X axis
xMax: 3,
borderColor: 'rgba(255, 99, 132, 1)',
borderWidth: 2
},
horizontalLine: {
type: 'line',
yMin: 70, // Position on the Y axis
yMax: 70,
borderColor: 'rgba(54, 162, 235, 1)',
borderWidth: 2
}
}
}
}
}
});
AI Readiness Guide from Domo
Is your dataset AI-ready? We're here to help.
Domo's AI Labs team put together a checklist so you can prime your data to be ready for any AI need or use case.
Download and save THIS AI READINESS GUIDE.
Then just follow the steps ✅
If you have any questions, post them in the comments below and I'll loop in our AI labs team for answers.
Re: How can I auto send an entire dataset each week?
You can attach a dataset to a scheduled report as an excel/csv file
Re: How can I auto send an entire dataset each week?
If your dataset is less than 5MB you can attach a CSV as an attachment:
You could also probably utilize workflows if the above option doesn't work for you.
Re: DOMO Mobile APP refresh(lose filters) when another app is briefly open
Hello Team,
We have also observed the same behaviour and because of that usability of the dashboard is decreasing significantly.
Re: Where is the subtotal chart option? thanks
it should be under Subtotal rows in the chart options to the left of the chart where you can enable the subtotals
Re: Where is the subtotal chart option? thanks
In the Chart Properties section, you need to select Show subtotal rows under the subtotal rows section and then the subtotal section will be enabled for each column.
Re: Sharing custom themes in App Studio
Custom themes are currently saved to an individual app.
To create custom theme, a user needs to select save as theme then it will store it to custom themes panel. We are working to add the capability to copy a theme from one app to another in the upcoming months that would let you use custom themes across different apps.
Current workaround is to duplicate the app and save that theme and use that new app!