-
Re: General question on data from different datasets on the same card.
@user048760 , the short answer is "a card can only be powered by data from ONE dataset". In short, no you cannot create a card that spans two datasets. What @Lady and @GrantSmith are sugges…1 -
Re: MYSQL ETL including parameters
Sure. just store the qeuery as table, and CROSS APPLY it to your table. Not sexy, but gets the job done. select * from `last_date_of_spent_data` or SELECT * FROM table , ( select max(date) as LastDat…1 -
Re: Count Distinct - it's counting blanks
@MarkSnodgrass is pointing out that an empty string, '' <> NULL. hence his test: TRIM(ID) = '' or ID is null HOWEVER, SUM ... 1 else 0 END will give you COUNT not COUNT (DISTINCT). @ekola , you…1 -
Re: Doubt in sharing the dataset to the users with PDP
@user069416 , you're mixing issues. 1) use PDP to determine what people can see data. 2) sharing is sharing. assume that eventually, EVERYONE will share EVERYTHING and therefore everyone will see eve…1 -
Re: generic OAuth redirection URL
just FYI @DP_DynamicData , the documentation has been updated since 2019, https://knowledge.domo.com/Connect/Connecting_to_Data_with_Connectors/Configuring_Each_Connector/Connectors_for_File_Retrieva…2