rado98

Hi As I recall: Step 4. Using the ETL Group function to generate the table. Group by MonthYear and Count Distinct Users, call new column "distinct Monthly Users" Step 5 Using the ETL Group function to generate the table. Group by Date and MonthYear and Count Distinct Users, call new column "distinct Daily Users" Join on…

Hi If you were to split your beast mode would you get Active Users:2215 Users: 2215 or Active Users:3273 Users: 3273 The answer might give you a clue. You might find the inactive users due nto come up at all in the activity log during the peroid or something like that.

The quickest way I found is to: Selet all and then delete one by one. Not a great solution but a quicker option.

Hi Can you show what your output cards look like. What you seem to be asking for seems not so hard, so maybe i am not undersatnding exactly what you need done. Tadashi's solution could problably be also done with a beast mode I think.

Hi The operatinos are escentially the same and the outputs is exactly the same. Joining usign SQL 22min Joining using Magic ETL 3min

Hi Thanks for the help, the system we use already has the option of uploading to google sheets so that is really the only realistic available workaround. I think I could work with the 15min update cycle ( in combination with the emails and "remove duplicates" in ETL. I would still like to know if anyone has found a…

Can we please have the response email in this thread. I had some issues and a detailed explanation would have been helpful

You could create a second tab in excel to do the automatic pivoting for you. Inconvient but that is how I would do it.

You can unhide the Job ID column, this should sort out problem 1.

The previously proposed formula will fix your issue, however if you need to use case statement (for another reason) the following should work I think CASE WHEN TRIM(`Country`) = '' THEN `Country_1` ELSE `Country` END

Hi Using Magic ETL you could create a column with the balances offset by month. Filter in only the AR Balances Use the Rank and Window tile to create a column with the amounts offset by one month Use Beastmode to get the difference Apologies for not being able to be a detailed as I would want to.

If you can fix min and max of the two axis, you could multiply the target value by a factor to scale it so that it looks like it belongs to the left axis. If have done something similar in the past. In a simple example, if your fixed axis are 0% to 100% and 0 to 4000. Multiplying a target of 80% by 4000 would give you a…

Hi I tried the same thing just now and got a similar result. I think the stacked plus bar style must have a bug in it. If you chosse grouped plus bar, which will look the same in your case, the graph will look the way you need it to.

Thing I do which may or may no help you is the following I create large large datesets by appending hystorical and current data. I need the data updated through the day so my timing would be different to yours. I would then run the historical part of the data, say all data from last year backwards once per day,…

Hi Any idea if there is a QuickStart App coming for Domo Governance? I really like to idea of this but it would simply take too much time I cannot afford to set something up that I could use. Cheers

Hi Any idea if there is a QuickStart App coming for Domo Governance? I really like to idea of this but it would simply take too much time I cannot afford to set something up that I could use. Cheers

Hi The Max Function would not work in this case Try using 'Today' instead of 'Week Beginning' on the second instance. Also try addign YEAR() to the beastmode otherwise the logic will break during the first 3 weeks of the year

I would say what graph is up to you. Maybe use Line + Bar Date the x axis Sum of Quota the line Sum of Booking the bar Alternatively, both as bar and the difference between the two as as line

Hi Try the following Create a job and have it generate a new data set. After the job has been created go to Domo Details under the Overview tab. There you should be able to change the target dataset by selecting an existing one.

Hi Ask your rep to set-up a fiscal calendar for your instance. They should have offered it to you on day one as it is very useful for things like this and you will get value out of it well beyond your current issue. Once that has been set-up the Date Range Selector on the standard calendar will do what you need it to do.…

Hi I would use and even simpler aproach Using Shelly's tables, but relabling Month in the quota dataset to match the date on the main dataset Main data set: Transaction Id Close Date Amount 1 01/01/2019 25.00 2 01/15/2019 10.00 3 01/20/2019 25.00 4 02/01/2019 25.00 5 02/15/2019 10.00 Goals data set (domo web form): Close…

I would start by breaking up the Account name into "Product Code" and "Fee Type", do this in either Excel or WB. After that join in ETL using the Product Code of that table to the Mapping Table. From there it should be quite easy to generate that output table. I think Sumo might work here or a transposed version of the…

I think for hte first part Beastmode will work well. Just cerate a Beastmode "Week" and use that as the "Date' on your table. If using in a graph "Graph by week" will get this to work (although that is such an obvilous solution that i am guessign it that not apply. For your indexed, nor sure what that data looks like, I…

Hi Building up on DanB's logic, you can probalby need the following too Concat( Year(DateField),'-', Case when MONTH(DateField) <= 6 then 'H1' when MONTH(DateField) > 6 then 'H2' end ) Thsi way you woudl get 2018-H1 2018-H2 2019-H1 And so which you will be able to use as an x-axis

Either create a beastmode that groups dates in yearly halves or create a data set with the grouping and joint to your existing data set. Then use the grouping in the charts

As for the time funtion If your data set doesnt already have every bussiness day of the month (future ones included) on at least 1 row I would add a column with total number of bussiness days for the month. This would need to be done by joining a to the data set I would join to the MTD Quota rows. So, crudely expressed…

The othe way of doing it, although it could generate more confusion is to have more than one beastmode/quick filter to select from

Depending on the card type, either show the average of quota or using no aggregation might work. This will not work if you then change the date grain to say yearly nor will a table total work either. If you need it to work under those scenarios, I would split the data set(sales and quotas), remove the duplicated quotas and…

I dont think it will ever work as you intended it to unfortunately You could set up a bestmode that is instead gives you Year-Month so you would be able to select each individual month. Not ideal but it will work

Depending on the card type, either show the average or using no aggregation might work. Thsi will not work if you then change the date grain to say yearly nor will a table total work either. If you need it to work under those scenarios, I would split the data set(sales and quotas), remove the duplicated quotas and reappend…