-
Stacked Gauge Capability?
I have a situation in which there are 2 contributing 'types' of revenue that contribute to a single target. Here is the general scenario: I have a gauge with a target of $10M I have a value of $6.5M that consists of two types of transactions. There is currently no difference between the transaction types visually, The…
-
Search that Leads to a Sale - BeastMode or ETL
I have 2 data sets. One is showing all of the search terms entered on our eCommerce site, along with the logged-in user's account info. I want to see if any of these search terms match with products sold in my second data set, which is all of the sales entered in our ERP. The intent is to see if an online search may have…
-
How do I use Fiscal Year in a Beast Mode?
I'm looking to create a case statement to indicate the fiscal year that a transaction occured in. Here is what I have so far: case when `SHIP_DATE` between '06/01/2014' and '05/31/2015' then 'FY15' when `SHIP_DATE` between '06/01/2015' and '05/31/2016' then 'FY16' when `SHIP_DATE` between '06/01/2016' and '05/31/2017' then…