Best Of
Re: Duplicate a card
The easiest way to do this is in analyzer. Just "Save as". You can either name your card the same thing or something different. These 2 cards will not be linked.
Alternatively, if you're wanting to do this with a dashboard, you can "Save as" the dashboard in the same way and create a duplicate copy where the cards are not linked.
Re: Conditionally show tabs in app based on user attributes
Love this idea @ellibot !
Re: Documentation on Activity Log Event/Action Definitions
omg +1 x10.
i love the advancements to DomoStats, hope the documentation improves in parallel.
Google produces really sick documentation on MIME types that might be an interesting format to follow.
Re: Random Number
@Ashleigh in that case, what if you did something with DENSE_RANK()?
DENSE_RANK() over (order by SUM(value) desc)
You could then do something like this
CONCAT('Customer ',DENSE_RANK() over (order by SUM(value) desc))
Re: Is it possible to upload many google sheets at the same time?
@Lu_zhang sure, happy to help. For an example, let's say you have the following 3 sheets, all with the same column headers.
Sheet1, Sheet2, Sheet3
You can use the following formula to combine all 3
=UNIQUE(QUERY({Sheet1!A1:C;Sheet3!A1:C},"WHERE Col1 IS NOT NULL ORDER BY Col1 ASC"))
You would adjust with your sheet names and columns. In this case there are 3 columns, so I go to Column C.
Unique makes sure that there are no duplicate rows, and also allows you to pull in the headers only once. It's important that there is a primary key in your dataset when taking this approach. In this example, I'm assuming that Col1 is the primary key (hence the NOT NULL check).
The formula that you see pulls together all 3 sheets into one.
Hope this is helpful!
Re: What's the best practice way to remove data from a partitioned dataset?
@DataMaven and @david_cunningham thank you both! I used the configuration setting to filter 2022 data out (after testing in another test partition) and it worked perfectly.
Re: How to apply filter to card that is always showing the most recent dataset update?
Good idea @DataMaven! Triggering off of the max week changing would be a good solution. @pauljames you would calculate this column in your ETL as well.
Re: Stream API - DataSet stack in Storing....
Typing on mobile is hard :) removed → recommend.
Re: BeastMode: New Field with Multiple Column Criteria
I think 3 beast modes is your best bet
case when application = 'App 2' then '' else application end
case when application = 'App 2' then '' else application_role end
case when application = 'App 2' then '' else client_name end