ST_Superman Domo Employee

@alliu can you share a screenshot for the filter card? Also, is the field being filtered a calculated field? If so, please share the code for that as well.

Looks like the series that you were using is Year. I would try creating a calculated field. Assuming you don't have any future dates in your data you could do something like this: CASE WHEN DATE_SUB(DATE_SUB(CURDATE(), INTERVAL 12 MONTH), INTERVAL DAYOFMONTH(CURDATE())-1) > DateField THEN 'Current' WHEN…

You must be missing something else. I have a "Priveleged" user role in the domo-community.domo.com instance which does not have the managa all cards grant. However, I can still share a dashboard that I created: I would confirm that your Custom Editor role has that "Edit Pages" grant: I'm guessing that it works similar to…

@Chaffin - any thoughts here?

@GrantStowell - Thanks for reposting the videos

I'm not sure how large your data set is, but I was able to accomplish this in Magic ETL in the following way… My dataset has two columns, row count and number. In this case, number is just a random number between 1 and 100. Added a constant to my dataset and duplicated the tile Cross Join the two tiles on my Constant value…

Hi @MycahD - You are on the right track. Do you have a max of 2 support staff per survey? If not, make sure to include up to the max in your split columns. The next step would be to leverage the DDX brick "Searchable Filter App (Multiple Columns)" You can follow along with @BenSchein as he walks through how to set up the…

:) How big is your watch? I have a hard enough time viewing some cards on my phone.

Are you wanting to set this Min/Max value on a variable? or on a page / card filter?

It’s difficult to help without knowing more about your issue. What is the case statement you are using?

sum(count(distinct case when AVG( SignUps ) >= AVG(`Target`) then StoreNumber end)) fixed (by Region ) / sum(count(distinct StoreNumber )) FIXED (by Region )

Just realized that I never finished my case statement here: Case When sum(count(‘ContentID’)) fixed (by ‘ContentID’) > 1 AND sum(sum(case when ‘JobName’=‘QC_Job’ then 1 else 0 end)) fixed () >=1 THEN ‘True’ else ‘False’ end

It does seem like this should be something that you are warned about prior to exporting. Did you want to post this in the Ideas Exchange @Ashleigh ?

I think that this would need to be done in the same ETL that you are using to add the order rank. Once you have each companies orders ranked in ascending order, then you would want to use a rank/window function to create a "Prior Order Date" field. This would be done by using a LAG function offset by 1 row and partitioned…

Are you an admin for your instance?

You could try a fixed function. Something like this might work: Case When sum(count(‘ContentID’)) fixed (by ‘ContentID’) > 1 AND sum(sum(case when ‘JobName’=‘QC_Job’ then 1 else 0 end)) fixed () THEN ‘True’ else ‘False’ end

Hi @Raymond - Welcome to the forum. I'll try to guide you through the basics, not knowing the structure of your dataset is or where you are getting stuck. Feel free to follow up with more questions if needed. The scatter plot chart type is found in the "Data Science" collection: Once selected, the fields at the top of the…

If you can, import the data as a string instead of an integer.

I would probably suggest a pipe | instead of a dash because that looks like a negative sign

@harropda - Are you looking for help in creating the new dataset? Or just if anyone has other ideas on how to accomplish this task? From what you have described, creating that new dataset should allow you to create the analysis you are lookin for. Ultimately, if you want your graph to display daily data, your dataset will…

@Ana I think that you could do this with a Pareto. Place BrandName in the Pareto Name and Sales in the Pareto Value. The graph will then tell you the % of total sales. However, if it needs to be a Bar graph, you can use a formula like this: SUM(Sales) / SUM(SUM(Sales)) FIXED (FILTER DENY BrandName) Using this formula…

@Tommy CASE WHEN QUARTER(CURDATE())=1 THEN STR_TO_DATE(CONCAT('12-31-',YEAR(CURDATE())-1), '%m-%d-%Y') WHEN QUARTER(CURDATE())=2 THEN STR_TO_DATE(CONCAT('03-31-',YEAR(CURDATE())), '%m-%d-%Y') WHEN QUARTER(CURDATE())=3 THEN STR_TO_DATE(CONCAT('06-30-',YEAR(CURDATE())), '%m-%d-%Y') WHEN QUARTER(CURDATE())=4 THEN…

Good catch @rco . If this is a filter tile that would explain the issue!

@jaeW_at_Onyx - He doesn't want to see the datetime difference though. He is looking for the amount of work hours between the two date time fields. So, if the workday is 9am-5pm. Then the time he would want for a job starting on Friday at 3pm and ending the following monday at 11am is 4. If you just did datetime diff, you…

translating: I want to use Beastmode to determine what unit is selected for the dynamic date range filter everyone thank you for your hard work. I would like to see in Beastmode whether the units are selected as quarters or months in the dynamic date range filter on the upper right of the Domo dashboard, but is there a way…

@shielmunroe I think that you will need to add a field to your dataset that will provide the prior days followers. This is because the calculated fields cannot do lag functions to check the value of the previous day. Do you think you could share a sample of your dataset? Might help someone get to a solution

@seanwayland - I think the easiest way to do this would be with using the Views Explorer. Simply create a dataset view that filters your large dataset down to a single report (or group of reports if that makes sense) and build content or share from the dataset views. Then the page will only need to load in the much smaller…

@jdorsch2 can you share what you have in your sort properties as well?

You tagged this appropriately. For this solution you will need to join the two datasets either with an append or combine tile in MagicETL. (you could also use a MySQL dataflow if you are more familiar with SQL) From there you can do some window functions to calculate the total sales in prior 30 days, etc. It's tough to get…

@mroker - in this case, because you have 4 dates in January… Would you only want to see the customers associated with Jan 01, which would be 20? If so, then @MarkSnodgrass has a great solution for you. Or do you want to see the sum of all the days (20, 22, 26, 29) or 97? or the average 24.25?