-
I have a chart which is populated yoy basis and has Q4 data being shown twice
Hi, I have a chart which is powered using a beast mode with a variable as following: (CASE WHEN (`Content Type ES Quarterly-2` = 'Project or Image') THEN AVG(`proj_image_insert_user_count`) WHEN (`Content Type ES Quarterly-2` = 'Project') THEN AVG(`customize_makeit_hva_user_count`) WHEN (`Content Type ES Quarterly-2` =…
-
How to Aggregate Daily Data into Weekly Totals in Domo?
I'm working with a dataset that contains daily level data, including a date column. I've created a calculated field based on this date column. However, when I try to aggregate the data by 'week' using 'graph by= week', I'm only able to see the values for each individual date rather than aggregated weekly totals. I've tried…
-
Adding custom font colors for a transposed row in a table
I want to label the positive numbers in green and negatives in red but only for the second row. How can this be achieved? Current chart settings is as shown below
-
Need different alignment types for columns
Below is a tranposed table, I need the 1st column to be left aligned while the rest of the numerics as center aligned, how can this be resolved?
-
Unable to use "AND" filtering
I have a column named "response_value" which is to be used as a global filter in the dashboard. I would like to filter distinct users who have all of the selected values under column "response_value". Currently, it works like an OR condition and counts users who were part of any of the response_value selected
-
beast mode using rank function
I have created a beast mode using rank() and using it to filter a chart. It is able to process the desired chart. But while saving the card domo says "There was a problem saving your card. If the problem persists, contact the Domo support team." RANK() OVER (PARTITION BY first_day_of_month ORDER BY COUNT(DISTINCT user_id)…
-
comapare current-3 days in period over period chart
I have a use case where the data gets updated everyday, however the complate data will be available only for current-3 days. How can I display a period over period chart to compare current-3 to current-4 days?
-
aggregating average value of a month
date any_hva 1/4/2023 123 1/4/2023 233 1/4/2023 234 2/4/2023 115 2/4/2023 111 I have a table in a following format, same dates are present in multiple records since there are other categories(not shown) in whichany_hva is split. I want to display a monthly chart in which I want to display average value per day. Just…
-
Creating a multi category chart
I want to display column "l1_dist_value" within the same date. Meaning the values of Hyperion, Artemis and Foundation should come within a single date chart as provided in the excel snippet. How can this be achieved in domo?
-
dynamic slicer selection on page
I have the following date slicer on the dashboard page and want the slicer to auto select the latest month. Is this possible?
-
Creating percentage change on trellis categories chart
Within an interval say 0-10 mins how can I show % change month over month in each bar?
-
How can I have only default filters to be visible on the filter views panel?
The selected slicers from the above page should not reflect in the filter views on top. I only want cohort and subscription filters to be displayed. Is there a workaround for this?
-
I want to create a 3*2 (6 lines) for percentiles by their engagement status.
I want to create a line chart with dates on X axis and 6 lines on Y axis. Is this possible with existing dataset?
-
Setting up alerts for delta change based on current vs previous week
I have a bar+line chart which is using 3 variables. I want to create alerts on all the individual variables for their weekly delta change of most recent week from its previous week. However, domo currently allows me to select an aggregation for all time and then compare delta change with aggregating the data for the new…
-
Deleting cards on domo
I have about 500 cards which needs to be deleted on domo. These cards are basically JPGs or titles which did not had any datasets. These cards are orphan and currently not owned y anyone. Is there a way I can bulk delete them in a go?
-
Setting up alerts on a weekly basis
I am trying to set up an alert for a metric for delta change in numbers since its previous week. However, I do not see any such option to perform that. Domo doesnot allow me to use any individual metric, rather select a particular date of the metric(image attached) Note:I do not wish to perform any aggregations on overall…
-
Display volume bar and 100% stacked bar chart as 2 options for a same card in a page
Hi I want to reduce the clutter in the dashboard page, hence I would want to see the bar chart and the 100% stacked bar chart in the same card when each of these options are selected as slicers at the dashboard level. I want to avoid displaying 2 separate cards as it consumes more space. Is that possible?
-
Beast mode to select all the slicers
I have a column that populates the below 7 options, I would want to have another option 'All' which displays numbers of all 7 cases instead of manually selecting all 7. I am trying to write a below beast mode for the same but the 'All' option would not include all of the cases. case when combination = 'desktop' then…
-
Disable slicers from being displayed as filters on top of the dashboard
Hi, I am using slicers in the dashboard but since the page is too long, I plan to duplicate these slicers and use them in the 2nd half of the page as well. However, I do not want to display these slicers on the top of the page as filters. Is there a way to disable the filtered view for slicers?
-
Divide numbers from same column based on criteria from another column
I have the following dataset, and would like to create a DAU/MAU ratio for each day. I would want to create a beast mode that powers this number and can be used to generate a line chart at daily level.
-
Have date range in x axis for week
Hi I have a weekly data and I want to represent date(x axis) as Jan "1-7" instead of "week 1" . Is this possible to do so in for a set of cards instead of changing this feature at an admin level? Thanks Chetan
-
Get Top 5 category values for each date from category
I have a column "category" which has more than 10 categories for each date. I would want to see only the Top 5 category for each date. Can I get a beast mode or a work around for the same. I have attached an image for reference.
-
Incorrect calculation when computing the value using case statement
Hi, The below beast mode in DOMO gives correct results when only 'metric A' is used as a filter in domo. When 'metric A' and 'metric B' is selected as a filter, the computed result goes a bit off. I have attached screenshots of the result. Note: The numbers changes for 5th Dec'22. Correct value is 72224.29 when used only…
-
Getting incorrect result while computing an output using Beast mode
Hi, The below beast mode works perfectly when only 'metric A' is selected as a filter. However, when 'metric A' and 'metric B' is selected as filter under 'metrics' then the resulting value changes. Note: I have attached a screenshot when the correct value is coming with only metric A as 72224, whch changes to 72213 with 2…
-
sum the value by week and display first/last day of week instead of week no. on x axis
Problem: Currently when we select a time range on the card by last x weeks, we will see the weekly aggregated values displayed by Week 1, Week 2, Week 3, etc on the x axis This poses a challenge to rethink on the actual dates when looking at the cards Proposed Solution: To display First/last day of week as a date instead…
