-
how to set up a filter based on the count of a non-numeric field
I wanted to create a table chart to list all users who havenot viewed certain number of files. I have a beast mode to get the number of files viewed using count(file_id). However, I could not use the beast mode as a filter? Can any one give me some ideas? Thank you. Olivia
-
page drill down?
Hello, I wonder if anyone has some ideas on how to do this: I created a campaign dashboard that presents overall campaign performance at high level across all departments. I wanted to do this: if user click on a campaign, it will bring to another dashboard that shows all detailed KPIs, metrics for this aprticuar campaign.…
-
How to give an indicator for a time range
Hello, Can someone give me some suggestions on how to deal with my case: I have a table with project start date and end date, I also know $ of each project, now I need to get the total $ for all project for each month and also compare with the previous month $. This is what I was thinking: get avg $/month for each project,…
-
how to get distinct emails
I have create a card to show the monthly subscriber, I then wanted to do a drill down to show the exact emails for the subscribers. However, there are dublications in the emails, how to only show the distinct emails? Thank you.
-
how to set a MAgic ETL to only filter out past 12 months data
My raw data contains 2.5 years worth of data and I only wanted to have the past 12 months of data for my next step dataflow to reduce the runtime. I wanted to do this in Magic ETL, is there a way to set up the date filter for last 12 months? I only see to set up a date filter for a specific date. Thank you. OZ
-
sum based on distinct in another column
hello, this seems to be straight forward, but I could not get it. I wanted to sum up the cost based on distinct code, but my beast mode does nto work: a sample data, I wanted to calculate sum of cost by distinct code, the sum should be 33. each code has the same cost. this is my beast mode: SUM( CASE WHEN(distinct `code')…
-
How to creat a filter for currecy change
Hello, I wonder if someone can give me some ideas on how to do this: I have a coulmn for SpendingCost that contains both Euro or USD. I created 2 new columns one for EURO as SpendEuro, and one for USD as SpendUSD by converting the currency. Now, in my dashboard, I wanted to set up a filter to let user choose currency type,…
-
Can the transform steps be adjusted in both SQL and Redshift
I have encountered this several times – I created a dataflow with many many steps. Later, I need to add additional steps or change the order of current step when a new data table is added. Currently, the new transform steps are always added at the end, there is no way to adjust the order of steps. It will be great if I can…
-
beast mode for last 15 days associated with page filter on Date
hello, I want to create a beast mode to calculate the downloads for the last 15 days when a user selected a Date from page filter, my current one is based on today's date. How to set up my beast mode? Thank you. Olivia SUM ( CASE WHEN `Date`> (CURDATE()-15) THEN `Download` END)
-
parallel drill down
Is there a way to allow user to do a parallel drill down? Current drill down path is not interexchangable. For example, I wanted to show email open_rate and click_through rate trend in drill down. But I can only get open_rate chart first, then go to click-through rate chart based on the selection from open_rate chart…
-
How to drill down with 2 datasets
I wanted to create a drill down in a card. The main chart and drill down chart using 2 different datasets, but both have a field called id. From main chart (a table chart with id in the table), user click the id and drill down to another chart. But nothing come out. Did I miss something? Thank you. Olivia
-
page filter for more than one datasets and hide the dataset
Hello, I have a couple of scenarios for the page filters, not sure how to do it: 1. Is it possible to hide the dataset, so users will only see the fileds that they can filter out? 2. Is it possible to set up more than 1 datasets and show them at the same time: I created a page using several datasets, and they have…
-
on24 webnar data
I wonder if anyone has expereicne with importing webnar/seminar data into Domo. We currently use on24 for our webnar and would like to import the data into Domo. Thank you for any information. Best, Olivia
-
% calculation for a table card
I need to calculate the percentage in a table card, the table like this:. I want to calculate the % based on Sent. e.g delivered % =4800/5000, Total bounce % =120/5000. I wrote this beast mode, but return nothing, can you please let me know what is not working. Thank you. Olivia SUM( CASE WHEN `Category` IN…
-
Can I bring several line charts into one
I have several line charts, since they are in different scales, so it is not good idea to use mutli-line chart, which will make some category looks too small, is it possible to build something like this? Thank you. Olivia
-
what is the best way to present summary with text in a card
I wanted to provide this information in the dashboard: the video with most view: video name, # of views. I currently built a table card to show the top 1 video and # of views. But ideas I wanted to have something like this, please give me some ideas. Thank you. Olivia
-
is it possible to insert a card in a table card
Hello, I created a trend line card, and wanted to show this trend line in a table card. Is it possible to do it? Or if there is another way to do it? Thanks, Olivia
-
Case Statement with calculation
I wanted to create a calculated field using case statement, but have a trouble to get what I want: I have a dataset looks like below, in this new calculated field, if Category is A( and many other categories) and Date is in last 7 days then SUM(Value) if Category is B or C (only these 2 categories) and Date is in last 7…
-
How to collect Youtube playlist title
I am trying to do some youtube analysis and would like to set up a filter base on playlist titles. I am using standard youtube report API pulling data in Domo. I can pull playlist id but could not find any report that has playlist titles. Can anyone help me with it? Another question related to Youtube: youtube playlist…
-
How to combine 2 cells in a table chart
I created a table card that inclues ID, category, lastmonth value, previousmonth value and % change. For each id, there are 2 categories, thus Id shows in both rows. I would like to combine the 2 rows for Id so that the ID only shows once. Can someone help me with it? Thank you. Olivia
-
Need suggestion on how to bring in huge amount of Adobe Analytics data
Hello, I am using Adobe Analytics Advanced connector to export data. I created my own dataset by using Intermediate -custom for report type, I selected 4 elements and 10 metrics. I also setup the following to include as much data as possible. However, because the data set is too big, I could not pull them into Domo via the…
-
Can you import Adobe Analytics data, facebook, youtube etc using Workbench?
Can Adobe Analytics data, facebook, youtube, Twitter data be imported via Workbench? Thank you. Olivia
-
date range for Adobe Analytics Data
I used Adobe Analytics conenctor to bring data into Domo. It seems it only pulls about 1 month of data, as of today it is from Aug 28 to Oct 1, is there a way I can pull all historical data into domo as I want to see a trend over time. When using the connector I did not see anything about date selection. However, looks at…
-
If I do not have enough authorization to a data source, can someone connect data in Domo for me?
If I do not have enough authorization to a data source, can someone connect data in Domo for me? Thank you. Olivia
-
Sharing filter views for only certain group of people
It will be great that after I created a filter and share it only with certain group of people. Currently, under Filter view, we can only either share with everyone who has access to the Dashboard or nothing. However, sometimes, we want to share the filters only to certain people. Thanks, Olivia