rahul93 Contributor

I can't delete the question, this has been asked previously and I have mentioned the link below. https://dojo.domo.com/discussion/52869/how-to-not-send-email-upon-user-creation#latest

@GrantSmith Can you not put an avg on the beast mode in the card itself? like avg after dragging the field onto the values placeholder.

I am not sure what you're trying to achieve here. But if you want the averages for both teams, shouldn't you partition it by teams as well? if you want the dataset to be filterable on teams and want to exclude a duplicate only during summarization, that won't be possible. You could partition it by teams and then show…

@jaeW_at_Onyx Hi, using a '' doesn't convert the field into a string field. I just tested it and it works as a numeric field. See screenshots Thanks

@mberkeley This solution would work for all companies, the only issue is that you would have put each company in a case statement. The filter will look like 'Company A' 'Company B' and so on and once you click on any one of them it will compare that company or companies (based on your selection) to the community. I have…

Hey @AnwarBham, One of the ways you can do this is by assigning a timestamp column to these tables and based on your loading times, you can write something that would delete all the historical data that you don't want in your tables. I would also consider what @jaeW_at_Onyx is saying. Your problem looks like data is being…

Hi, Instead of 0 in your code can you put '' in the beast mode. So if budget or actual value is 0 then '' . Does that give you what you need? Thanks

Hi, One way you can solve this problem is by creating a beast mode. So let's say you want company A & community values. You can say something like: case when "Filter Column" in ('Company A', 'community') then 'Company A' when "Filter Column" in ('Company B', 'community') then 'Company B' end Basically, you can't filter 1…

you could try to create 2 beast modes, 1 for calc and other for label. Calc Beast mode : count(case when `date` <= current_Date - 5 then `incident` end) / case when `date` <= current_Date - 5 then 5 end Label beast mode: case when `date` <= current_Date - 5 then 'Last 5 days' end Note: I have only given for 5 days, you can…

Hey! Any idea if this has been released yet?

Generally, if you update the dataset, the card updates itself with the fresh data. I have also built a similar piperline where the data updates every 15 minutes. The card updates every 15 minutes to show fresh data. I wouldnt call it a refresh since the page doesnt refresh. The card just flickers and shows new data. Can…

Its not clear what you are trying to do here. You mention automating, what are you trying to automate? Are you trying to save the snapshot infomation in a table (automating this task)? Some more information will help in answering this part. If you have targets for these numbers, I would use a bullet chart for displaying…

Please remove this idea suggestion. People have mentioned this previously. My apologies.

I believe one way you can do this is : 1) By creating a copy of the dataset you want to duplicate. 2) Go to the existing dataset and go to "Cards" and click on the Switch cards to a different dataset and choose the copy of the original dataset. 3) This should ensure the beast modes flowing into your duplicate dataset. 4)…

For drill down you can use a separate dataset that has the detail level data (and not the aggregated data). The only thing to keep in mind would be to have the same field in the detail dataset on which the user is going to drill on.

In order to create what you want, you would choose the line + stacked bar char. Create a column that has the percentages and values. For example : Base Dataset: A | B qw 10 zx 10 as 10 Target Dataset: A | B | C | D qw 10 V 10 qw 10 P 33.3 zx 10 V 10 zx 10 V 33.3 as 10 P 33.3 as 10 V 10 V stands for Value and p stands for…

the column you want to convert to a numeric/decimal column contains the character '$' and doing this wont be possible unless you remove the character. Also, I have never used a cast function in a beast mode and i dont believe it exists. To replace the '$' character you can use the replace function and then multiply it by…

Okay, so you dont need to create a batch file for each job manually. When you click on a job you can simply go to the toolbar and click on tools -> schedule. This lets you create batch files for jobs automatically and also allows you to add multiple jobs to single schedule (single batch file for multiple WB jobs).

Ah my apologies i thought you wanted the last 7 days from today. I believe you wont be able to do this in a beast mode with the existing fields. Since, the data loads every 15 minutes i dont believe creating a dataflow would be an issue unless the dataset isnt too large. 

Hey, Let me know if this works. sum(case when `activedatetime` >= current_date() - 7 then 1 else 0 end) thanks

I dont believe there is any way to get Job IDs for all the jobs except going through each job at a time. Also, what are you trying to achieve by using batch files (just curious).

Hi, Did you try using the Line + grouped/ Stacked Bar charts? You can go into the general properties and mention the number of series you want to see as line graphs. Lets say you mention 2, it chooses the first 2 series based on sorting to be displayed as line graph(s). let me know if you have questions.

You will have to do it manually using math functions .

Did you end up recreating the beast modes? 

Hey, One way could be to create a generic admin account like ["Company Name" DOMO Support] and assign all cards this owner and then assign the "now" owner to a policy. let me know if you didnt understand something.

might want to use a case statement for blanks and nulls. Case when trim(`country`) = '' or `country` is null then `country` else `country` end

Use a Line + stacked bar. Sort your series such that the cumulative percentages are first followed by other categories. Making the percentages first ensures that they appear as a line. 

Hey Becki, I am not sure what you mean by YTD terms if its Current Terms then the formula could possibly be: SUM(Case when YEAR(`dateOfTermination`)= YEAR(CURRENT_DATE()) then 1 Else 0 End)/…

You can use beast mode: Current Terms/ (Datediff(STR_TO_DATE(concat('01/01/',YEAR(Current_Date()))),Current_Date())/DATEDIFF(STR_TO_DATE(concat('01/01/',YEAR(Current_DATE()))), STR_TO_DATE(concat('31/12/',YEAR(Current_Date))))) Note: I assumed that Current Terms is a field in your dataset. Let me know if it works or not,

The same way you were going to update the dataflow every 15 minutes. Instead of telling the excel job to update every 15 minutes you update it everyday at a certain time. Please comment if you find a better solution.