Best Of
Re: Creating a Manager Span of Control Chart
Are you requiring it to be in a tabular format? You could get something similar with a Sankey chart where you'd just need your data to have two columns:
Boss Title | Report Title
Re: using Regex with email connector
@NathanDorsch Try this: .*RMP.*
For future reference is a great resource to test whether your Regex works as expected
Re: Question of how to mark or pass data for certain amount of records
Hi @mhouk
I built a Magic ETL that will get you pretty close to what you are looking for
1st on your data add a column and name it "ROW" that states the row number in your data.
2nd open a magic etl and copy/paste the code attached
3rd connect your input and name your output
4th run it and review the results
your output should look like this (the highlighted columns are your original fields in the spreadsheet)
Godiepi
How to delete rows from an input dataset and replace the dataset
I was trying to use SQL transformations, but I cannot make the output dataset the same as the input dataset. Could someone help?
Re: How to delete rows from an input dataset and replace the dataset
Thank you for the detailed explanation. I did not know about the DELETE command, and that was very helpful.
While this is a significant improvement from what I thought I could do, there's still this issue that remains:
The new data that comes in is never obsolete. Its only after a certain time that it becomes obsolete. That means that I cannot instantly do operations on incoming data, rather I have to store it in a dataset, and keep running delete statements on that to remove unwanted data.
So while my end output in purged, there is this huge dataset in the middle that I still have to maintain.
Any idea on how I can reduce the size of the middle dataset as well?
How to purge data from an existing dataset via API?
Hello Domo experts,
We are trying to find a way to use the API, or other non-UI approach, to purge all the data from any existing Domo dataset.
A little background may help...
Our company (Anonomatic) provides an add-on to Domo called PII Vault. What it enables is for Domo customers to get full Domo functionality but never have to load customer/patient/etc. personal identifiers (PII) into Domo.
That process works just find and we have healthcare and financial services customers happily using it. However, we recently had some requests from our Domo customers to enable them to take data which is already in a Domo dataset (Dataset A) which has PII in it and run it through our process to create Dataset B which will not have PII. Because of what we do, Dataset B can be made available to basically anyone in their organization without worrying about data privacy issues and they can still do everything else they would do with Dataset A.
The problem is that once we create Dataset B, the data in Dataset A is still there and so the data privacy issue is not fully resolved.
Deleting Dataset A is not an option. They have existing jobs that populate it and they do not want to have to change them. Instead, they want our process to run after it is populated and then clean it out once we are done.
So back to my question. Is this possible? We have scoured the Domo API documentation but there does not seem to be any way to delete records from an existing dataset.
We even tried importing a single blank row into the source dataset but because the dataset was not created via API, it cannot be modified via API.
Thank you all,
Re: Grant Stowell- Community Forum Moderator at Domo
Great to have another gamer dad on here @GrantStowell ! Looking forward to great conversations.
Re: Beast mode errors in dataset views
It might actually be that your IN does not have a space before it so it is reading accountIN as one thing, when it isn't.
Re: How can I identify all the users who have looked at/viewed a DOMO card in the last year?
Hi Charles,
To identify all of the regular users that frequent particular DOMO cards and pages, you can use the DOMO platform's user activity logs. These logs will give you detailed information about the users who have accessed a particular card or page, including the dates and times of their visits. Here are the steps you can take to retrieve this information:
- Log in to your DOMO account and navigate to the card or page you want to analyze.
- Click on the "More Options" button in the top-right corner of the screen and select "View Activity Log" from the dropdown menu.
- The activity log will show you a list of all the users who have accessed the card or page, along with the date and time of their visits. You can filter this list by date, user, or event type to get a more detailed view of the activity.
- You can export this log data to a spreadsheet or CSV file by clicking the "Export" button at the top of the screen.
Once you have identified the regular users of a particular card or page, you can reach out to them to redirect them to the company accepted standard DOMO card/page. You can also use this information to consolidate similar cards and pages, reducing the number of unnecessary duplicates. This can help to streamline your organization's data and ensure that all employees are working with the most up-to-date and accurate information.
Let me know if this helps.
LWalker
Re: Distinct List_Agg
@NateBI Yes, you can add DISTINCT inside the list_agg function the same as you would to for a distinct count like this:
List_Agg(DISTINCTcustomer_name, ' / ')