-
Re: want to have day/day last year numbers
@julia_wang it would be helpful to know what columns you have on the axis of your pivot table. (post a screen shot). also please post the beast mode you've written and include data structure... makes…1 -
Re: How to create a filter to capture the end of month
build a date dimension where you have one row for each day of the year. then assign the week_of_year to each date. then it'll be easier to make these comparisons. "build a date dimension" i…1 -
Re: 'Lookup' in Beast Mode
@utkarsh please articulate in business language what you are trying to accomplish. @MichelleH is correct, you can probably accomplish what you need using Window functions (the LAG() function) in part…2 -
Re: Combining data into one pie chart
@louiswatson you could have significantly simplified your ETL by using a FORMULA tile with a CASE statement. The reason why this approach is cleaner is the CASE statement allows you to use an ELSE cl…2 -
Re: If possible, how can I call a Stored Procedure or Function?
@Jose_Rojas yes, you would need to work with your AE to get the Jupyter Notebook addon. If it was me, i would be VERY explicit and adamant that you do NOT need the Data Science Package. IMHO with the…2