jaeW_at_Onyx Coach

It may not be possible in Sumo cards, but definitely acchievable in anlayzer. https://www.youtube.com/watch?v=ZPf41Fjn1H8

I would restructure this data in ETL. If Tax is the same across all invoice lines, take your Invoice Lines and Remove Tax. then add a column with a fixed value of "Invoice Lines. Then UNION a copy of the data with one row per Invoice for Tax. you can put amount into the same column or have a separate column for tax amount.…

In Tomo's example they are doing a row_number() over the marketing_id column (this can be done in SQL or Magic ETL, but given what you described, I don't think that's what you're looking for. @ST_-Superman-_ said it best, for problems like this, a sample of data would be most beneficial. if i had to guess, you have two…

Just FYI i have an entire tutorial playlist dedicated to tackling financial reporting in YouTube. If you're trying to construct an income statement using transactional data, here's a video that might help you get the layout you're looking…

... "the best way" ... please appreciate that i'm operating off of a napking drawing :P. if it were me, yes, this is how i would structure the data. i might try to find shortcuts like excluding outputting rows where subscribed = false. but with the information available, yes, I believe normalizing the data is the better…

convert your week into either the first or last day of the week and then you can easily do a datediff.

in a dashboarding application the person who gets the most value out of your dashboard should be the person who views your data... given that domo does not target analysts, the reasoning of the sales pricing is that the viewer should cost as much as an editor license. there are grants that give users 'view only rights'.…

http://www.mombu.com/microsoft/t-informix-interval-values-into-a-datagrid-14795206.html

Sorry this is going to sound snarky, but it's not meant to be. Did you google it? Domo uses standard tooling like C# or .NET and ODBC drivers to connect to databses in workbench and then convert it into a format that can be sent into Domo. So if you have difficulty extracting data from your source system, a lot of times it…

Doesn't look like it. Use a different chart type? I'm particularly fond of the Bullet Chart.

Just to clear up any confusion ... it's not 'Domo MySql' it's MySQL 5.6.28-76.1-56 -- just run SELECT VERSION() Your ETL is being processed in a MySQL database engine, it is not 'Domo flavored' in any way. Except that the platform is automatically converting your SELECT statement into a SELECT INTO TABLE. It's unclear…

While you may be able to hack your way to a solution, the best answer would be to reshape your data. Use MagicETL and the Unpivot / Collapse Columns transform to collapse your data into 3 columns (ID, Subscription Name, and isSubscribed).

@MartinB not seeing your code, if i had to guess you're having difficulties with asynchronous functions. domo.get is an async function (hence the use of .then). so all your rendering has to happen inside the .then function unless you're using state to store the data. if your function is domo.get(query).then(function(data){…

@rgbuckley no video required! ? it sounds like you want to apply a filter (Park) that then applies a 'looser' filter' on the data (State). The short answer is ... no the Domo UI can't do that yet. An upcoming feature 'Filter Groups' may help with that. What you can do if you only have a few parks per state, you could…

you may have to use a different chart type (chart / line) or bullet chart, but then just create a beast mode with the current date, a series, and a value. yeah... that's ugly. you could use a data label with a custom value (setup a beast mode) that's only populated on the current date. I've had clients change the chart…

i do not know 100% but would not be surprised / it would make sense. APIs wouldn't want to stream billion row datasets to you. instead it would be secure (in case of network interruption) to send data in n-sized row chunks. so ... yeah.. makes sense. in a similar way, i would not read the data directly into a pandas…

given that you have a graph, it's unclear to me what you do and don't have done. that said a few things to consider. 1) ignore fiscal year. or fiscal week. as i understand it, your question has nothing to do with a calendar year, it's just "did behavior change before and after training." that's irrespective of time of year…

i know this isn't the answer to your question. but consider using a different visualization. if the slice of the pie is so small that the UI doesn't render a label, it will probably be very difficult of a user to clock the difference between group 1 and group 2. at most, they'll think "oh... that's a huge difference."…

can you be specific about what's not working?

just FYI i believe that mathematical operation is called "Modulo" or "Modulus" https://www.w3schools.com/sql/func_mysql_mod.asp https://docs.microsoft.com/en-us/sql/t-sql/language-elements/modulo-transact-sql?view=sql-server-ver15 @GrantSmith i noticed you wrapped in Round , 0 to get rid of trailing decimal places. I guess…

to the original poster / @MichelleH and @Ashleigh , the design of the dataset was flawed which is why the user struggled to solve their problem. "Operational Places" is grouped by "ACPR Name" and "Organisation Type". "Number of Clients" is grouped only by "ACPR Name" in a different ETL, hence why the numbers are the same…

it might benefit you to start a new thread b/c it's unclear if your problems are actually related to the initial issue. either way. definitely do not make 100s of beast modes! that would be such a PITA to maintain. if you have multiple "Types" in one column, experiment with putting Types in "Series" or "Categories". Also,…

contact your CSM. this is a beta feature in development.

you mean other than the KB articles?Which grants you give will have a lot to do with how you structure your domo implementation. how do you plan to segment people. how will you handle inter and intra departmental data? who will be building content? who will primarily be consuming content? Focus on what adoption and rollout…

it is unlikely that the data from mixpanel is presented in the original way that it was stored in the database. keep in mind when you extract data from mixpanel it's being sent as a JSON object which by definition means that it can contain data stored in a non relational format (instead of single value fields, a JSON key…

just convert your column to Numeric then back to text and take a LEFT 1.

Instead of aggregating the data with a SUM() I would simply UNION the data on top of itself, and then assign a hard coded value of "Rep Owned" to the first copy of the data in the column that usually contains "Accept" or "Converted". THAT said, assuming you're working with salesforce or similar data that tracks…

you won't see the schema in the Domo UI until you load data.

 in table cards you can use HTML + CSS to display images (or format text) https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Adding_Graphics%2C_Links%2C_and_Images_to_Table_Cards_Using_Beast_Mode

You haven't stated what's going wrong in your code ... maybe try wrapping date in a MAX() function