@ArborRose How did you go about enabling scheduled refresh in PowerBI so the data from Domo via the ODBC stays up to date ? We are currently trying to install a gateway but running into issues.

@Manasi_Panov thanks for your context. Based on the variable video I believe if I want the card to interact with the date range filter on the dashboard the summary table is the best option. I was just hoping to avoid creating another table for something this simple. My comparison is always PowerBI where I can just create a…

@ColemenWilson LAG() doesn't appear when I search functions in beast mode. Any thoughts ?

@ColemenWilson can this be done in beast mode or is your example done via magic ETL ? Additionally, would this methodology work if you had a transaction table with day date granularity or does your methodology require you to create a summary table truncating the day > month ?

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