-
Transforming Date Range to Zero
I have a simple dataset that has activities over time. I like to break that down by week so I can see the week to week workload of the team. For some of the activities being tracked in the data there might not be anything so in my line chart it shows as a blank and the line graph breaks. I've looked at "hide empty values"…
-
Subtract Dates
I'm trying to exclude old items from my card. I'm using the following as a simple filter but it comes back as invalid. What am I doing wrong? Yes, I've confirmed they are both date fields. (CASE when DATEDIFF(`Close Date`,`POV End Date`) > 365 THEN 'Do Not Count' Else 'Count')
-
Grab the most current entry
I have a dataset with a list of activities. For each opportunity I want to grab the most current update/activity show those notes. so for a proof of concept, I might have the following: Activity Date. type description 1/1/2021. environment buildout. Built stuff to support POC 1/5/2021 project kickoff things are going…
-
QoQ Comparison By Week
I can't seem to get the right combination to make this line chart work. Series 1 = Q1 Series 2 = Q2 Series 3 = Q3 Series 4 = Q4 Line comparison by week (week 1-13ish) each plot is the count of activities that week Anyone point me in the right direction?
