MichelleH Coach

@Highland This would be nice. I do want to point out that there is a simpler way to accomplish this without the formula tile in current state. All you would need to do is have a filter after the join to only include rows where the join key from Table B is null. Hopefully that makes a slightly easier work-around in the…

@luizalauretti Yes, exactly!

@gbrown A beast mode filter would work, with a couple changes: CASE `Date` <= DATE_ADD(CURDATE(), INTERVAL 2 MONTH) and `Date` > DATE_SUB(CURDATE(), INTERVAL 1 MONTH) THEN 'SHOW' ELSE 'HIDE' END

@luizalauretti You should be able to create the second table using a Group By tile in MagicETL that groups by PPG, RE, and TYPE then takes the Sum of VALUE. Then you can use an Add Constants tile to create a new AREA column with a value of "SP".

@luizalauretti Can you please provide some anonymized examples of what your data looks like and what you want the result to look like? It sounds like what you described should be possible in ETL, but I want to be sure I'm understanding correctly before offering suggestions.

@gbrown Here is the knowledge base article on how to configure the Rank & Window tile in ETL: https://domo-support.domo.com/s/article/360044876094?language=en_US For your situation, you would want to use a framed average or sum, ordered by Date. To calculate the 3-month average you would set Preceding = 0 (start with…

Agreed! It would also be helpful for finding cards when you don't remember the name or page where it resides.

@damen You can configure the date format on the X-Axis under Category Scale (X) > Date Output Format

@gbrown You will need to use a Window function for this calculation, although those functions are not supported in Domo's version of MySQL. You would have to use either the Rank & Window ETL tile or write it in a beast mode.

@lb1234 Try using DENSE_RANK() instead of RANK() to make sure numbers don't get skipped

@zuchu Instead of THEN `State` = 'TX', just use THEN 'TX' and see if that fixes the issue.

@renee12345 What result are you currently getting with that calculation, and what result are you expecting?

@renee12345 The CURDATE function does not accept any arguments in side the parenthesis, so you would need to move the -1 outside of the parenthesis in your previous day calculations.

@gbrown Can you please share the beast mode you are using?

@Rsandoval Does your output dataset actually contain 0 rows or does the dataflow history just show 0 rows updated? Depending on the schedule settings of your dataflow and Quickbase connector, it's possible that no rows were updated but the existing rows still exist in the output dataset. If a dataflow is triggered and the…

@n____l____ Removing the "end" after your concat function should resolve the syntax error. If the nulls are still an issue, then you may need to update your 19 columns to show an empty string instead of null like this: case when `Corporate Product Lines Owned` like '%Student Information System%' then 'Student Information…

@n____l____ Do you have a list of all possible products that could appear in the list? If so, you could use a formula tile in ETL to create a column to check whether each product is listed. For example, the column to check whether Student Information System is in the list would look like this: case when `Corporate Product…

@Jigar_Thakkar What interaction settings to you have configured for that card in the dashboard?

@Katie_Forrest_2022 Your second beast mode is returning 0% because you are using a combination of OR and <> in you case statement, which is logically true for every row in your dataset. So for example, Discrepancy 121901 is not Discrepancy 121275, so it meets the criteria of your second exception. I generally prefer to use…

@Katie_Forrest_2022 Your second beast mode is returning 0% because you are using a combination of OR and <> in you case statement, which is logically true for every row in your dataset. So for example, Discrepancy 121901 is not Discrepancy 121275, so it meets the criteria of your second exception. I generally prefer to use…

@apatten You also had spaces extra spaces in your date format qualifiers, which would prevent it from recognizing the dates. @ST_-Superman-_ 's formula should fix that.

@Tommy Sounds like a bug. I suggest you open a new case with Domo Support about this.

@Vova Can you please share the details of how you set up the calendar dataset join?

@ellen The only work-around I can think of is to restructure your data in a dataflow to add total rows to your data with a value of "Total" in the field you want to define the columns in your pivot table. The challenge with that is that could get messy if you want to apply filters to your card.

@ellen No, there is currently not a way to change the position of the total column in a Pivot Table card. Feel free to upvote this Ideas Exchange post requesting the feature add: https://dojo.domo.com/main/discussion/56272/pivot-table-total-column-position#latest

@chapman Can you please share the fixed and window functions you've tried?

@aldwinB From what I can see, your Excel formula is looking for 'AB' at the end of the Category field, but your ETL formula is looking for it at the end of `Product Group name`. That may be contributing to why you don't see the same results. Also, the correct syntax for checking for nulls is Category IS null, not Category…

@jrtomici Do you have a maximum number of items that could be in your comma-separated list? If so, you could use the Split Columns tile in MagicETL to break them each out. Then you would need to create a branch of the dataflow for each split to filter to the rows that have a value in that position and rename the field you…

@charles Yes, you can create a hierarchy of pages by creating "Subpages". You can read more about it here: https://domo-support.domo.com/s/article/360043428253?language=en_US

@Domomon Fixed functions are only compatible in Beast Mode. If you are using MagicETL, but the Rank & Window tile provides similar functionality. Based on your use case, I would suggest using a Row Number function, sorted by Connection Date and partitioned by Entity ID in the Rank & Tile Window. Then you can use a formula…