Hi I have created a date field in my dataflow using this formula to give me the current date: DATE(TODAY()) I am trying to use this date field to get a snapshot of the data every time the dataset refreshes. I have my dataset scheduled to refresh every Friday. The first Friday the dataset refreshed it gave me the correct…
Hi, I am trying to create a drill-down visual for a bar graph in my dashboard but the fields I need to create the drill-down visual are in another table and when I either join the tables or replace the table for the drill-down visual when I hit save and close it asks me if I would like to create a new view. Wondering if…
I am trying to find the percentage of the cost of sales from the total cost of sales. I have used the following calculation in beast mode. (`Cost of Sales` / (SUM(`Cost of Sales`)) However, this calculation is not returning accurate values the lower cost of sales values have a higher percentage than the higher cost of…
Hi I am trying to use a case statement with a When and Then clause inside it. The formula I am putting in is basic and has worked for other tables but not working for the one I am currently working with. I have tried these formulas: 1. CASE `SeasonalDescription` WHEN 'Easter' THEN 'Spring and Summer' ELSE 'Other' END 2.…
