ST_Superman Domo Employee

@user02631 I think this would be easier if we could get a sample of the data. Would you be able to share a sample of your dataset? Ideally, it would need to contain 2 or 3 groups with several of the items from each group. Feel free to anonymize the names of the items or groups, but without understanding the dataset…

Is this beastmode being used for a summary number? Mind sharing the rest of the chart settings?

You won't be able to perform this kind of analysis in beast mode. You would need to capture the prev 7 day average in a dataflow and then you could do the calculation comparing it to yesterday either in the beastmode or in the dataflow.

This may still be in beta, if so you will need to request access to it. However, I can add a summary number to a text box when using a dashboard layout.

try dropping the else 0 off of the end of the case statement (edit) @Godiepi apparently I should have refreshed my browser before posting my suggestion

You could use ETL or MySQL dataflows to filter your larger dataset or create partitions so you can download smaller datasets into your r environment

You can do this from the admin section

Try adding some else 0 clauses to your case statments: (ABS(SUM(case when `Code` = 'F' then `quantity` ELSE 0 end)) + ABS(SUM(case when `Code` = 'H' then `quantity` ELSE 0 end)) + ABS(SUM(case when `Code` = 'I' then `quantity` ELSE 0 end)) + ABS(SUM(case when `Code` = 'J' then `quantity` ELSE 0 end)) + ABS(SUM(case when…

I feel like you would want to remove the Cost from this funnel. Maybe provide a seperate visual that would display cost per click, cost per application, cost per hire... Clicks, applications, and hires are all measuring the same thing, so I think you could make it work with those stages. Do you have a target for how many…

You need to change your thinking slightly. Try splitting it up into two steps. First grab everything up to and including the first pipe, then replace with '' then grab everything from the second pipe on and replace with '' what will be left will be the desired value between the pipes

First of all... yes, you can do this in an ETL. However, I am not the best at creating some of these more complex dataflows via ETL. So I'm sure that there are probably more elegant ways of performing this within an ETL, but this is the best I could do. I decided to keep the product detail in the output dataset because I…

Last question before I get working on this. Are you looking to aggregate this per location? Per product (company wide)? or per product and location? or are you looking for company wide metrics (across all products and locations)? Because the calculation is being done in the dataflow, it forces the agregation to be static.

How is your data structured. This should be pretty straightforward. To replicate this graph you would want to build a bullet graph. 2018 volume would be the “target” and 2019 volume the ‘actual’ value.

Have you looked into the workbench tool?

It looks like this could be done with 2 filters on the card 1. Place the `AssignmentGroup` field in the filters section and select 'IT Ops T1 Tickets' 2. Place the `ResolvedBy` field in the filters and select the "not in" option and then the null box (if the second filter doesn't work then you may need to use a beastmode…

I answered this in another chain... @user14340 - Can you provide some sample data so that I can test it out with your schema? I'm not sure what is causing the issue. I might try count(`SalesHost`) over (order by sum(`NesSales`) desc) but i'm not sure if that is valid or not. @user14340 also commented that the rank()…

Are you sure that you're looking for the population variance? I also don't think that you would want to use the else 0 in your case statement because that will increase the N value. You should try: VAR_POP(CASE WHEN `deploy_date` >= '1/1/2019' and `deploy_date` <= '3/31/2019' THEN `delivered` end) / VAR_POP(CASE WHEN…

I agree. I think you will need to engineer this field within a dataflow. Are you always going to want a running 7 day total? Is this already part of an ETL or MySQL dataflow? If you want help manipulating the dataflow, please share the input file structure and any steps already in place.

You can also just use: concat(`Sold Price`)

@user14340 - Can you provide some sample data so that I can test it out with your schema? I'm not sure what is causing the issue. I might try count(`SalesHost`) over (order by sum(`NesSales`) desc) but i'm not sure if that is valid or not.

If you select the Line+Group Bar type, there is an option under the general chart properties to allow you to do this:

To answer this question, we would probably need to see the Select statement you are using to join your data together. Mind sharing?

And you are looking for the tag on the dataset, not the tags for the specific fields on the dataset. Let me do some digging around. I'm not aware of any off the top of my head though.

Or you could upvote my idea: https://dojo.domo.com/t5/Ideas-Exchange/Add-Field-Descriptions-and-Tags-to-the-Domo-Governance-Datasets/idi-p/41075?advanced=false&collapse_discussion=true&filter=location&location=idea-board:Ideas&q=schema&search_type=thread

You could use a 100% stacked bar chart to show the percentages. Actually, I’m pretty sure most bar graphs give a data label setting to show percent of total. You could also use beast modes to display the information in a table horizontally. But you would need a separate bastmode for each metric. Radio SUM(CASE WHEN `media`…

Do you mean to use a custom .svg to link to another page? thats an interesting question. I’ll have to dig into that one. You can use html code to create page links with an image from within a table card. 

I would also check any other filters on the card, make sure that if you are filtering for say "store number" or "Country" or something like that, the filter may be blocking the future looking dates in your dataset. Try pulling off any filter and see if that provides the forward looking dates.

Because you are looking for the max value, I am going to recommend using the Group By tile.

I did a little bit of testing to confirm my previous post: I think it really depends on your expected result. I used three different beastmodes to test the outcomes of each. 1. count ifnull COUNT(IFNULL(`count`,0))) This was testing the denominator in your original field. This does, indeed, count a value for every row even…

Could you try this as your beastmode? sum(CASE WHEN `ParentStore` = 'Store 1' THEN IFNULL(`Valuation To Sale Amount Variance`,0) end) / sum(case when `ParentStore`='Store 1' and ABS(ifnull(`Valuation To Sale Amount Variance`,0))>0 then 1 else 0 end) I'm pretty sure that this expression will count the 0's as a value as…