Is there any way to send the output of a card (XLSX or CSV format) to an SFTP server? We are looking for a way to schedule weekly updates of a report and have it automatically sent to an SFTP director…
Hi Everyone, I have data at a daily level for every month. I am trying to plot averages (monthly) over time. So for example, if I have 30 rows for June 31 rows for July, I would like to see 2 bar grap…
I am doubtful that it is possible, but I'm holding out hope that somebody might have some insight. In excel I can take the values of two different cells per row to calculate a percent change, but in S…
Hello, I want to make a dashboard where i will have 2 single value type cards, one with the YTD for the current year and the other with YTD for the previus year. I've computed both values trough ETL w…
Hi, As the title suggests, I have a Gantt chart of project timelines, and I want to be able to add a hyperlink to the Y value so that when clicked on, it takes you to the relevant project link. I have…
I'm looking to work out the average time in days from 'Instructed' to 'Completed' (both dates), I'm using DateDiff but the returned value is -151 for some reason. Is there something I am doing wrong w…
I have a dashboard with cards running on multiple datasets (5+). To make date selection easier for users I've created a beastmode titled exactly the same across all datasets to show Q#-YYYY. There are…
I am trying to use our actuals to track past month/current value and our forecast to use future month value and I am having trouble writing the beat mode to do this. CASE WHEN YEAR(`Period Date`) <= Y…
Hi guys! I am trying to clean bunch of time codes and I have a first line code that's valid, but I am having trouble cleaning other codes such as 'hourly' and 'salary' lines of code without error. cas…
