-
Averaging a date value
In our dataset we have a driving date of greg_d, but also have other date values for things like sales start and end. These values can change based on program changes and in order to see these changes I wanted to calculate an average sales start and end date associated with each greg_d. Is this something that is possible?…
-
Trouble showing only %_percent_of_category labels on a 100% stacked bar
I am wondering if it is possible to show only my label settings even when hovering and hovering on the legend in a 100% Stacked Bar. The card is currently set up to show labels of %_Percent_of_category so in the default it only shows % labels (see second attached screenshot). I also have my hover settings adjusted to show…
-
Multiple Level Aggregation
Hi all, Running into an issue when trying to do multiple levels of aggregation in a beastmode calculation (not sure if it is actually possible as a beastmode). I have a dataset that looks something like the below with data at the item-location-day level and a servicing DC associated with each store. What I am attempting to…
-
Y-Axis Starting at too high a value
I have a card that is a mix of stacked bar and line. The stacked bar and two lines are on the primary axis while the final line is on the secondary. The issue I am running into is that the y-axis scale is way to large consistently. It is currently starting at a value of 50 billion and the max value of any data point is 15…
-
Is it possible to create a chart with a single bar and multiple lines?
I am trying to model out several data series that are correlated and want to show the relationship between them as they move from day to day. I currrently have a mulpile line graph with three different lines. I am looking at changing one of the series to a differen type of visual (Bar or fill) to show it is a baseline…
-
Using Date value within Case statement.
In the below case statement I am trying to look at product that is on order to our warehouse, and have it breakout by expected arrival timeframes. I am not sure if casting the `RDC_ETA_STATUS` as a date or using a value of current date() + is a potential way of creating the ranges so any help would be appreciated. (CASE…
-
Beast Mode as a quick filter (save issue)
I have a beast mode case when statement that doesn't involve any aggregation that I am trying to use as a filter. It is relatively simple and I am using it to try and look at one particular warehouse against all others. I am able to add this in as a filter and it works fine the only issue I am running into is when I try to…
-
Nested case function (average over time period)
Hello, I am trying to build a card that has dynamic goals incorporated into it based on the 30 day history. The below is what I currently have set up as the goals based on the mdse_grp_ref_i which allow it to roll up to higher level goals based on the mix of items that fall into each grp. (case when `mdse_grp_ref_i` = '1'…
-
Blank Drill Paths
I am working on making updates to some cards that I am not the owner of, but do have edit access on. I can make the updates to the card in the analyzer, but when I try to make edits to the drill path it shows that it is blank. I know these cards have drill paths and I am curious if anyone knows why I might not be able to…
