Manasi_Panov Coach 
-
Re: Number of business days in the month
Hi @user060355, You can create a CASE statement in Beast mode (my 'date' colum name is 'submitted at'): CASE WHEN DAYOFWEEK(submitted at) = 1 OR DAYOFWEEK(submitted at) = 7 THEN 0 WHEN DAYOFWEEK(subm…1 -
Re: Alter Column: file to convert type String to Date
Hello @verytiredgirl, Why don't you try Dynamic Unpivot instead of Unpivot? If your data initially includes columns for Jan 2024, Feb 2024, Mar 2024, and Apr 2024, start by Add Constant tile, then pe…2 -
Re: Beastmode to return current month value? And what's the best card type to show the variance?
Hello @verytiredgirl, There are no issues visualizing the Current Month Target and Actual. If you have data spanning multiple years, please include the year in the Beast Mode formula. Examples are pr…1 -
Re: Beastmode to return current month value? And what's the best card type to show the variance?
Hi @verytiredgirl, The current month is 9. From what I can see from the table, there is no data for the month of September. Could you please check?1 -
Re: Highlight pie chart slice by filtered selection
Hello @calebtyrone , Instead of applying a filter, you can create a variable that displays the necessary supplier information on all cards. I believe there may be a workaround to highlight only the s…1
