-
Re: Can you stream Salesforce data in real-time?
+1 with @MarkSnodgrass , except it's important to keep in mind that even the webhook connector executes (and therefore ingests data) in batches. despite it collects data from a webhook pipeline, it m…2 -
Re: How to build a filter for only the most recent value of a column in a data set to show.
only addendum I'd add to @MichelleH 's post would be to not filter out rows. just add your row_number for nth-most-recent visit. in one card you can filter on "nth-most-recent-visit = 1" an…3 -
Re: Ignore Row Context / Power BI 'ALL()' Equivalent?
@zcameron here's a recent compelling use of FIXED!1 -
Re: ETL Formula to Change a column of city, state, zipcode to Just portray State
use splitpart to split the text strong on the comma delimiter split_part(`addressfield`, ',', 2) wrap those results in a trim to remove any leading whitespaces. then split_part on the space and keep …1 -
Re: Can PDP be changed at the card level?
@ST_-Superman-_ i had 2x options! but for good measure, here's a third. 3) i suppose you could preaggregate the data at the rep level and then add category metrics as columns. (but eww gross pre-aggr…1