-
Re: Connecting Monthly Goals to Incoming Cumulative Daily Data
You'll need to aggregate your raw data up by month/year in an ETL and then do a join on month/year and whatever your goal descriptor is. Another option is to use a date table and a cross join with yo…1 -
Re: How can I avoid denominator should not get filtered while calculating the percentage in beast mode
@SwapnaE you can use FIXED functions to achieve this in your denominator. Say your filter column is called ColumnB, and you want to allow a date column (DATE) to filter COUNT(ColumnB) FIXED (FILTER A…1 -
Re: Charts on distinct values
You can do COUNT(DISTINCT id) @EWG IT Corporate Your example data Beast Mode Result1