-
Magic ETL - Using Group by - run time impact question
Wondering what is the best practice to reduce overall run time of a ETL dataflow... I've got 5 input datasets totalling about 14M rows of data that are ultimately appended together in the final result. Is it better to use group by in the magic ETL for each dataset (5 steps) or one consolidated step after the appends? Also,…
-
Magic ETL - Add a "Flag" column based on comparing a date in one column to current date
In my data I have a date column. I'd like to create a column via Magic ETL (want to use in a filter) that looks at the date a determines if it is in the past or in the future. Here is a short video that explains. From an Excel formula standpoint, it would be: =IF([@[Last Update]]>TODAY(),"Future","Past") I tried with value…
-
APPROXIMATE COUNT (DISTINCT) or COUNT (DISTINCT)
Can anyone explain the difference in these two functions? Why use one vs' the other?
-
Beast Mode: Percentage of Total Inventory - comparative gauge
I'm trying to build a comparative gauge to display the percentage of total inventory. * Attached is sample data * Here is a video I put together to explain Where this is tricky is keeping the total inventory value for the calculation. Can you help?
-
Need some help: Two Beast Modes
I've got two Beast Mode calculations related to supplier receiving measures I am having trouble with. Hoping you can help me transfer my Excel knowledge in the example here over to Beast Mode. * Attached is a workbook with sample data, example of the finished report, and explainations of the calculations. * Here is a video…
-
Beast Mode Help: Two layers of division
I've got a calculation I am trying to perform with a beast mode formula, that I can't get to work. The calculation is (Number of Lines / Hours Active) / Standard I'm trying to protect against divide by zero in the two layers of the formula. The first item in the order of operation is the (Number of Lines / Hours Active),…
-
NCAA Football Data source
Anyone know of a FREE data source for NCAA football?
-
New Dynamically Based Range Scale Markers - outlier fill?
I'm reviewing the Sept Release Notes, and can't figure out how to do outlier fill with the new dynamically based range scale markers. In the Adding Scale Markers to Your Chart knowledge base document, the card example given in the intro shows fill color for the "normal" range of data as green, and the red for fill area of…
-
Poll Cards - any way to get the number of responses?
Poll cards display the % of responses for particular items based on what the users select. I would like to know how many responses there are for each poll card. 80% out of 4 responses has much less impact than 80% on 400 respones.
-
Control Charts - Mean, Upper Control Limit (UCL), and Lower Control Limit (LCL)
I posted a requested in the Idea Exchange for a new chart type, Statistical Process Control Charts (link below). I wanted to ask the Dojo if anyone has done something like this already? What I really need to be able to include in a line chart are the Mean, UCL and LCL values. Plotting the actual results with those lines…
-
Want card to "ignore" a particular page filter
I have a card (see below) that when a user filters the page by `Year` I don't want it to filter. In other words, I always want it to show all of the `Year` values - ignore that page filter. Ideas on how to best accomplish?
-
Choose "Year" in Page Level Filter - display Year and Prior Year
I have a brain bender (at least it has been for me). I have a card I want to display "Sales vs Prior" - if the user chooses a "Year" (2015, 2016 or 2017) in the page analyzer I want this card to display the year they picked, and the year prior to that choice as well. Any ideas on how to approach? I have attached sample…
-
Widen the Scale on a Line Card, and leave it dynamic (not set values)
In the card displayed below you can see that the default scale is displaying the values in a very tight grouping. I would like to widen what is displayed (reduce to range of the scale). I know I can do this by setting the scale values to specific numbers, however this causes issues when filters are applied for business…
-
How do I refresh an Excel DataSet manually?
I'm just beginning (please have mercy), I uploaded an Excel DataSet and in building cards I realized I needed to make a change to the Excel book. After making the change I want to refresh my DataSet (and the cards I have already built) with the updated data. I cannot see how to do this? Maybe I'm just missing something…
-
Scheduled Reports - add grant to create, edit, manage (roles)
This would be a huge gain for my user base if they could schedule their own reports (participant users).