MichelleH Coach

@lb1234 What method of comparison makes the most sense for your business? Would you want to exclude days 29 through 31 of the current month, or something different?

Hi @Manasi_Panov in order to compare values from different rows, you will need to first use LEAD function in a Rank & Window ETL tile () to identify the values of Work Type and Order on the row above. Then you can use a CASE Statement in a Forumla tile like this: case when Order = Next Order and WG Combi is NULL then Work…

@tom_rotchadl Your thought process is correct, though you have a couple syntax issues in your formula: The equals sign is not needed in Domo, which is slightly different than Excel The Training Hours and Employee Email fields are being read as text values because they are surrounded by singled quotes. You will need to…

Hi @PJG you could do something like this: case when Actual Costs < Planned Costs*1.01 AND Actual Costs - Planned Costs > 20000 then 'Over Budget' when Actual Costs > Planned Costs*1.01 AND Actual Costs - Planned Costs > 5000 then 'Over Budget' else 'Under Budget' end

@karlysindelar_2023 Of course! It looks like the values in your datset are negative, but you can display these as a positive number by creating a Beast Mode () to use as your Y-Axis value instead: -1*`Credits issued`

@karlysindelar_2023 Yes, you can change your date groupings by opening your card in Analyzer and changing the Graph by setting to Week instead of Month. Here is a KB article on how this works:

@karlysindelar_2023 Once you've created your dataset you can find it in the Data Center, which you can find by clicking the DATA icon on the top of your screen Then you can go to your dataset list on the left navigation menu to search for the dataset you've created. Once you find your dataset, open it and navigate to the…

@lb1234 Do you have Status as your series in the chart? If you do, you could just use the Percent of Category macro in the Data Label Settings. Note that if your two bars are made up by separate beast modes this will not work the same way

@Stucker A couple notes on your formula: Campaign is being recognized as a text value instead of a dataset field when using single quotes. Wrapping it in the ` character should resolve this You will need to include the % wildcard when using the LIKE operator. If WBH is always at the beginning of the string you can use like…

@ArborRose That's because this is an Ideas Exchange post. That option is only available on posts initated as a question, using the "Ask a Question" button on the Community Forums main page

@ArborRose I believe that option is only visible to the user who originally posts the question, which is why you cannot see that on other people's posts

@Stucker Try removing the CONCAT functions in your formula since that will prevent your calculation from seeing your fields as a number. Also, do any of your 6 columns have null values? If so, you will need to wrap each field in an IFNULL(`fieldname`,0) since adding nulls across the same row will cause values for the…

@Thomasvanharskamp I'd suggest starting with this write up that @GrantSmith made on period over period comparisons:

@Zel I agree with @RobSomers that your dates are likely getting duplicated because they are datetime rater than date. Forcing them to a date should help.

@Zel Do you have a date field in your dataset or just month? If you already have the date then you can create a Pivot Table card with Healthcare and Date in the columns and Unique Alarm ID in the values. Then you can sort low to high by Date

@chrissy Instead of using the "Limit Rows" feature in analyzer, add a filter to your card using the Row number field you created in your ETL to only include rows where the row number is less than or equal to 20

@Utz To clarify, are you referring to Dataset views or drill layers? I'm not sure if Dataset views count against row limits, but you can reach out to your AE or CSM to confirm.

@chrissy Of course! Have you named the output dataset? In your earlier screenshot it looked like you had not named it yet, which would prevent it from running

@tom_rotchadl@tom_rotchadl How many cities could be listed in a single row? I'd suggest using a combination of the Split Column and Dynamic Unpivot ETL tiles:

This is a great idea! This would be helpful for validating PDP policies

@chrissy There are two steps involved in the Rank & Window tile: selecting the partitions/order and then applying functions. So far it looks like you've only competed the first step. Here is an article on how the tile works: In the Rank & Window tile you will want to order the functions on Total Activity (2) descending (3)…

@Zel I believe that is the case. If you already have your two original cards showing the values, then I would suggest using just the percentage in the filled gauge card

@Zel Yes, to show percentage you would update your value field to divide the count(distinct Alert ID) by the case statement currently in your max value field. Then you would set your max to 1 (100%).

@Zel Since your calculation for Remaining Balance requires subtracting the Total Alerts/Events Used, I would actually recommend using a Filled Gauge card instead of a Donut/Pie chart. In this case you would use COUNT(DISTINCT Alarm ID) for the gauge values and the total amount of credits as your Optional Max Value. Also,…

@Zel Since these cards are on the same dataset, I'd recommend creating a beast mode that mirrors the logic of each card and segments your data between "Total Alerts/Events Used" and "Remaining Balance" to use as the series of the donut card. Depending on how your original cards are set up you may need to create a second…

@Zel Are both cards on the same dataset?

@pstrauss If you're using MagicETL, I'd recommend a combination of the Group by tile and a Filter Rows tile. In the Group by tile, group by user_id and create the below formula to check whether all of the rows for each user_id have a value of "false_inquiry": case when count(case when inquiry_type = 'false_inquiry' then…

@chrissy You will need to use a formula in the Group By tile instead of the Formula tile to use a COUNT(DISTINCT ) since that requires aggregating the data.

@Utz If the fields don't already exist in the dataset used to make your bar graph then you will need to join it to the dataset that does have them through a dataflow or view. If your original dataset is already the output of a dataflow then you can add the join to the existing dataflow.

@chrissy If Total Activity is a beast mode, then you will need to recreate the calculation in ETL using a Forumla or Group by tile, dependng on whether it includes aggregation