Hey Team! I am trying to filter a dataflow to just show the sales that we had from 10/12/2023 - Current. What filter formula can I use to accomplish this?
I have the data of different segments and want to represent it in a single dashboard. To make it user-friendly, I want to make an index table stating all the segments and I want that when I click on the name of that segment or the link (which can be created in beast mode) from the table, to navigate to that particular…
I have a requirement to calculate previous year's data (in monthly format - Month Over Month). So if user selects Fiscal year 2023, he should be able to get data for 2022. Only catch is that 2023 means Oct-22 to Sep23. So 2022 would mean data comparison between Oct-21 to Sep22. Any help would be greatly appreciated.
Example Parts: '0055656','1248000', 'D9989008','0556767P' I need to exclude rows where the third and 4th part in list above exist. First and last characters can be any member of the alphabet. Thanks, Mike
I am trying to do this with magic ETL but I am not having much luck.
I have a row that contains model numbers such as: YM103Kl - (model category would be YM and capacity is 103) YAC24LT (YAC and 24) NC33KLT (NC and 33) I'm trying to figure out how to extract the initial letters (2 or 3 depending on the model) to identify the model category and the subsequent numbers (single to triple…
I have a row that contains model numbers such as: YM103Kl - (model category would be YM and capacity is 103, and capacity multiplier is K) YAC24MT (YAC and 24) NC33KMT (NC and 33) I'm trying to figure out how to extract the capacity multiplier. @GrantSmith helped me to identify the model category and capacity with the…
I have a data set that has a row for each customer each day with their rolling 30 day average user engagement score. So columns would look something like customer_id, customer_name, engagement_score, date. In a separate table I have customer churn data, with columns along the lines of customer_id, customer_name,…
I have formula logic to try to standardize insurance company names. I use a series of case conditions to try to create a new field with standard naming. But my logic doesn't seem to work the way it would in SQL. My formula contains searches such as… CASE WHEN LOWER(insurance_company_name) LIKE '%aetna%' AND…
CASE WHEN "SUBSCRIBERS" < 10000 AND "Youtube engagement rate" >= 3 THEN "Micro_HighEngagement" WHEN "SUBSCRIBERS" < 10000 AND "Youtube engagement rate" >= 1 AND "Youtube engagement rate" < 3 THEN "Micro_MediumEngagement" ELSE "Micro_LowEngagement" END it is failing and saying column not found , how to resolve this , please…
It looks like you're new here. Sign in or register to get started.