PodiumMason Contributor 
-
Re: How to address gaps in date ranges in visuals?
Hey D-Rab! There are a couple potential solutions here. One of them rests within the "Value Scale (Y)" chart properties (I'm using the single bar chart as an example). There is a check…2 -
Re: Case Statement in Magic ETL
Hi Nick! There is a transform options in Magic that allow you to do case statement functionalities. Under the "Edit Data" transform grouping you have the "Value Mapper" transform.…2 -
Re: how do i change a date grain on a card
Hi there! In the "edit card" screen, next to the card title, you should see a drop down displaying the current date range and granularity for your card. Simply click the drop down to open t…2 -
Re: YoY Beast Mode Issue - "Issue Occurred While Processing"
Hey @user07803, At a glance, the issue with your beast mode is the initial CASE statement. CASE WHEN `Actual Revenue` = 0 THEN 0 Beast mode gets pretty disagreeable when you try to mix row level calc…1 -
Re: Calculating Percentage based on multiple dates; calculations based on date selection
Hey @user03841, You could do this with a beast mode (or multiple beast modes) and either hard code the date ranges you want to look at, or use the card date range to adjust the beast mode dynamically…1
