-
Filter Out Current Week in WoW Card
Hi, I'm creating a Period Over Period card that displays number of tickets created as a week over week comparison. I'm running into an issue: I don't want to include the current week since the results are incomplete. * When I use Date Range = This Year, Graph by = Week, and Compare to = 1 Week ago: The Card includes all 52…
-
Change display of medium card on page to clip left side
Is there a way to change the way a medium card is displayed on a page so that it clips the left side of the data instead of the right? For instance, I have a Line chart with dates on the x-axis from a specific start date, 3/15/18, till now from left to right. As the date gets further from 3/15/18 the x-axis gets longer and…
-
Add values from Web Form row as Columns to a Dataset
Hi, I want to use a web form dataset to allow a user to enter values for 4 variables. Basically, a single row with 4 columns for the variable values. I want to then add these values as additional columns to each row in another dataset. What is the easiest way to do this? The use case is, I want to be able to use the…
-
How to create a backlog trend card?
I'm trying to create a card that shows the trend of case completion against a backlog each month (based on open/close dates). Ideally, it would be a multi-line chart with 'month-yr' on the X-axis and COUNT of cases on the Y-axis, for the following series: * New = COUNT of cases opened during month * Closed = COUNT of cases…
-
Beast Mode - Parent of Parent type join
I have a data set of project items at multiple levels of a project hierarchy: project > task > sub task. I'm trying to build a sort of rollup card that shows the items based on parent link relationships. i.e.: * Project Parent = Self * Task Parent = Project * Sub Task Parent = Task I'd like to be able to have a column that…
-
Incorrect Column Type Preventing ETL
I'm trying to use Magic ETL to transform a dataset using rank&window and remove duplicates. My ETL keeps failing due to the error "Failed to parse data as integer for column". I attempted to input a "Set Column Type" step connected to input but the ETL is failing at the "Input Data Set" stage and never reaches that point.…