calvert_schaefer Member

To answer my own question, the script above actually works via suiteanalytics connect in Domo

@GrantSmith the saved search connector is terribly slow. I've seen run times of > 12 hours for under a million rows so that isn't an option

@Jbrorby the equivalent to Magic ETL in PowerBI is the power query editor. It doesn't give you the visual tile layout like magic but instead it records each step in a list. Instead of drag and drop you select Transformation options from the header section of Power Query. Historically the downside of PBI was the ETL would…

@TaddGibson are you still gathering feedback for this thread ? If so I'd be happy to connect. I spent 5 years working with PowerBI everyday before my current role which already had a Domo environment.

@ArborRose the value I'm using is a beast mode = sum(`value`). Additionally my dataset does not have 2 value columns, just 1 with a column delineating the forecasted account . Here is a sample. I have attached above as well.

Unfortunately that gives me the same result. Here is an example of my underlying dataset. The value I'm using is a beast mode = sum(`value`). Here is an example of the dataset

@ArborRose I believe in your example you are sorting the Y axis alphabetically. I am trying to sort the Y axis based on Sales Dollars.

@jessdoe thanks.

@jessdoe thanks for the response. While that would work in theory keeping time across the X axis of the pivot table is important

@AaronCrouch thank you! I was going through the same thought process on Friday because I swore they use to be different as well. I will submit a ticket of my own

@jrudd unrelated to your question but how did you setup your data labels in this bullet chart ? I am currently building one and for some reason my Actual Value and Target value show the same label but when I hover the values are different which is the expected result

@marcel_luthi thanks for providing an example. This solution works however it requires me to always display the time horizon as All Time for the running total of Daily Doors. How would i go about creating the measure that calculates the running total? My first guess is sum(sum(`Daily Doors`)) over ( order by `Date `)…

@marcel_luthi thanks for the detail. I have tried this in my model and unfortunately I am getting the same results as previously. I have tried it on a simpler measure of Reviews in the example below. Date View = CASE WHEN DATE AXIS='DAY' THEN Review Date WHEN DATE AXIS='WEEK' THEN Review Date - INTERVAL(DAYOFWEEK(Review…

@marcel_luthi regarding the variable method, do you have any examples or further context you can provide? I'm assuming your variable would be day, month, week, year and that selection would drive the graph axis as well as the order by of the measure

@colemenwilson I am using the over() to create the cumulative total