rado98 Contributor

I explained myself incorrectly, the first image is how the card looks like already in DOMO. I would like to get the other views to match it.

For reference this is where the "Log on as a batch job" policy can be found.

Thanks for the tips, I run into that duplication issue a while ago so I am mindful of it every time I import a job individually. So far I have not had that issue using the newer whole Workbench Backup feature. If anyone reading this needs a reference to another Impersonation issue and fix, this was my post about it:

The issue was solved As explained the user I was trying to use was part of the "Domo Workbench Users" group so the reported error message did not make sense. The issue arose from the fact that on installation WB adds the "Domo Workbench Users" group to the "Log on as batch job" Policy but then the new network system…

Hi Were you able to sort this out? We are having the same issue.

Quick update (still having issues though) I did a full clean re-install of WB. Restart after un-install, restart after re-install, waited 5 min after the last restart to let WB initialize without me poking at it. It worked fine for a day, impersonation was working fine. Thought that the issue was gone, closed the support…

Yes it is, as shown on the screenshots above.

Going thru the support process now. I'll post the outcome when the time comes.

Thanks for the suggestion. I already manually run selected jobs using batch files (to get around the limitation WB monitoring network files for changes) but as I have some 150 excel jobs manually running all of them would be a nightmare. Plus I think I would run into all sorts for issues, from way too many jobs running at…

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.

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…