JonFass

Discussions

Stacked bar + line chart doesn't stack
Hi all, I'm trying to create a stacked bar + line chart that shows revenue amounts as bars broken out by revenue type, and the line as a count of contracts signed / won. I've used beast modes to break down the revenue amounts into different columns by type and use that as series. However, no matter how I set this up, the…
Setting up a count off of different date rules in ETL
Hi everyone, I'm trying to set up a column that would show me how many workdays to pay a consultant for, depending on how many days they worked for over the month. The variables are whether the start or end date was during that month (and so they would only be comped for that part of the month - from start to month end of…

Stacked bar + line chart doesn't stack
Hi all, I'm trying to create a stacked bar + line chart that shows revenue amounts as bars broken out by revenue type, and the line as a count of contracts signed / won. I've used beast modes to break down the revenue amounts into different columns by type and use that as series. However, no matter how I set this up, the…
Setting up a count off of different date rules in ETL
Hi everyone, I'm trying to set up a column that would show me how many workdays to pay a consultant for, depending on how many days they worked for over the month. The variables are whether the start or end date was during that month (and so they would only be comped for that part of the month - from start to month end of…