I am trying to schedule a weekly report that would be sent out every Friday morning for data between the previous Friday and Thursday of the current week (7 days/1 week). For example, data range is 3/3/2023-3/9/2023 for this week's report, whereas next week's report would be data range 3/10/2023-3/16/2023. Is there a way…
Hi All, When joining tables in the MAGIC ETL, how do I include the table name as a prefix for the columns? Sometimes the 'Select Columns' transformation offers a rename suggestion in the format, 'TableName.ColumnName' but it is not always suggested and requires using the 'Select Columns' transformation before each join.…
So I am trying to write a Case statement to select a different field to pull a value when the primary field has a blank value… Something like: CASE Parent Carrier ID WHEN 'null' THEN Carrier Name ELSE Parent Carrier Name END I don't know what to enter as a valid term for ‘null’ to represent looking for empty values?
I am always trying to find a way to detect what the user has either selected for a date on the card or the dashboard when building my BeastModes. Can Domo not find a way to pass this in as say a Macro or something. And I am saying Macros for both the card and dashboard level date selections
I have a dashboard that displays information with a field containing a person's id. On one of the cards, I display an image of the person. The card uses an html table to display the person by calling an image url. When I try to export the dashboard to PDF, the export fails. If there any way to tell Domo to ignore a card…
Hello Team, I have a requirement in the table chart where columns are months like Jan, Feb,Mar,.. , Nov, Dec. I need to hide column months which are not having any values inside it
Percent ranking answers what "% of values were less than Y." Kudos to @GrantSmith for the question. This is useful for comparing test results in two populations. Imagine 67 respondents tested 75% or les whereas in group B 99 respondents scored 75% or less. To calculate % rank, you calculate the rank and divide each rank by…
I am looking for ways to take 2 timestamps, a start, and an end timestamp, and chart them to account for a user's activity that day. I am using call center agent status times and want to have a bar chart for each agent that shows their status for the day and then plot in the calls that came in with wait time and talk time.…
I want to hide and show cards on the dashboard if user selected any filter then hide some cards and if user remove that filter then card should be visible.
Last year someone asked whether there is a way to see the last activity for a card, but it did not get directly answered. So I am asking here. Specifically, I need to do a major clean-up of old cards and dashboards that are no longer used. To do this, I need a report on the last activity date (the last view). Currently, I…
It looks like you're new here. Sign in or register to get started.