Best Of
Re: How to create dropdown filters within a card
This is not possible within a card, however you have some options:
1. Create a dashboard and add drop down filters above your table card on the dashboard
2. Add quick filters to the table card to filter the data, these will be either single select, multi-select or match values filters - Not a dropdown.
Dashboard with filters example:
Quick filter example:
How to create a dashboard:
How to create quick filters on a card:
Re: Magic ETL Possibility?
A more straightforward method rather than multiple CASE WHEN statements is to use SPLIT_PART
SPLIT_PART(`Fruit`, ',', 1) -- First in CSV SPLIT_PART(`Fruit`, ',', 2) -- Second in CSV SPLIT_PART(`Fruit`, ',', 3) -- Third in CSV
Governance toolkit - User management
Hi
I'm about to implement User Governance and have some concerns about user passwords.
1- I assume that existing users that are already in the user management dataset will keep they current user password, right?
2- What about new users passwords that will be created once I create the job? How will they get his password? (For ex, they will receive an email notification and will be able to configure his password from a link)
Thanks in advance.
Re: GA4 connector stopped on Importing ...
I'd recommend logging a ticket with Support to have them help diagnose your connector issue as they own that connector.
Re: Best Practice - Columns to Rows?
You can use the Dynamic Unpivot tile in Magic ETL:
Results:
Re: Best Practice - Columns to Rows?
@Data_Devon It depends on your use case. Having your columns wide will allow you to consume fewer rows overall, potentially reducing your costs. On the other hand, Domo likes things as rows to deal with filtering. If you want to filter your records based on the City, then you'd need to pivot your locations stomore easily filter the records.
Re: beast mode
I've re-read this like 10 times and can't figure out exactly what you are trying to do. Could you share once again slightly differently? Or maybe show two excel samples: what the data currently looks and how you would like the data to look with the beastmode?
Re: beast mode
I understand now, thank you! Yes you will want to do what @ggenovese recommended.
Re: How to show events that happened after a selected one?
Hello @ggenovese,
It's super nice how a single problem can be approached in various ways. I'm sure we can think of a few more solutions. It's really about @0RNGL4DY and what will be done later with the Beast Mode and visualizations to determine the most suitable approach for his case.
Re: How to show events that happened after a selected one?
Hi @0RNGL4DY, @ColemenWilson,
This method is effective only if all "Person" entries attended the A conference. If the first conference is B and you wish to check attendance for C, D, etc., an alternative approach is recommended.
I suggest using a Pivot to transform rows into columns, enabling multiple strategies to achieve the desired outcome.
And the result:
