ST_-Superman-_ Coach

I don't think beastmodes like the BETWEEN clause. Instead of: SUM(CASE WHEN Instrument Fiscal Year BETWEEN SEG PMPK CAGR Start Period AND SEG PMKA CAGR End Period THEN Instrument Qty END)),1/(SEG PMKA CAGR End Period-SEG PMPK CAGR Start Period+1))-1 Try this: SUM(CASE WHEN Instrument Fiscal Year >= SEG PMPK CAGR Start…

I agree with @GrantSmith here. By using a fixed function, you should be able to check each date against all other dates coming through the filters. I would be curious to hear if this didn't work.

You can also combine the Tootip Field and the datalabel settings to display multiple values. However, the Pie value will only take the first into account.

This is a great idea +1

@NathanDorsch - is it because you are bringing in the same dataset multiple times?

@Backslash You can also use the chart properties to only label the datapoints for the line if that makes it cleaner. Another option to increase visibility would be to make the line thicker.

You can use the window function tile in Magic ETL. The function want to apply is LAG. This article gives more info, scroll down to the Rank & Window Tile section:

The brand kit options are fairly limited as well. Especially if you are wanting to make sure your dashboards are using your company preferred font.

You can do something like this with a Symbol + Stacked Bar chart You can also just view it for a single time period:

Yes, you can use the "Limit Rows" option to only show the number of items you want: In this example, only the top 10 products are displayed, but the total still shows the overall total for the time period

If you used a variable to set the current month and comparison month, then you could write a beastmode to get this calculation. But then the user would need to set those values when they view the card. (you can select a default value, but unfortunately the default can't be "current month". You would need to update the…

My understanding of the faceted bar chart is that it is good for combining charts that are measuring the same thing. In this case, it looks like you are measuring three different things at once. Since the top two are both looking at a count of opportunities or evals, those will probably work okay in a faceted chart, but I…

@domoexpert What type of visualization are you using? You can accomplish this with the Period over Period "Variance bar line" chart type:

@user046467 One solution could be to adjust the chart properties. For example, if I use the Maximum slices before 'Other' property from the data you provided I can change the graph to show the desired result: The advantage to this, is that you can mouse over the "Other" pie and see what it contains as well:

@muahmmad_zaidi I would attempt this by leveraging variables. Two variables that would allow the user to select which quarters to compare. You may need to actually write these out in a list: '2022 Q1', '2022 Q2', '2022 Q3'… Then use a calculated field: SUM(SUM(CASE WHEN CONCAT(YEAR(`Date`),' Q',QUARTER(`Date`)) =…

The Group by tile will work if you want to perform this calculation in ETL. However, the downside there is that the total will be calculated based on the logic that you build into the ETL. For example, if you partition your totals to give you the total monthly sales you would not be able to change the data in a…

@JohnnyN - Depending on how you are bringing the data into Domo, you could also change your dataset to be an upsert. If you search the knowledge base for upsert you should be able to see which connectors have this option.

Try this? CONCAT('<div><a href="https://www.adp.com/" target="_blank">',`EmployeeID`,'</a></div>')

Your case statements don't have any clause for when Geography/Product View = 'P&L' Either add an else 1 at then end of each case statement, or call out a specific value for each option that the user can select.

Thanks. I thought your series was breaking up bars into multiple segments. But you are just using is to add colors. If you set the Colors using Color Rules, then you can avoid using Series. This will allow you to keep the min max and avg values:

It's always helpful to have a small sample of the dataset to help understand the structure of the data. However, from your description of the fields, I'm assuming that your data may look something like this: With each project having a single row of data and multiple columns of data that contain the different "go live"…

@PJG What does your data look like? Do you have one row of data per project? Or one row per go live date? When you summarize your data, are you using Count? or Count Distinct?

@caiopimenta Can you share a little more about your data and what your expectation of the min/max/avg values you want displayed would look like?

@Jones01 the state of the original card will carry forward into the drill path. If your base card is graphing the data by week, then your drill path will do the same. If the user changes the base card to graph by month, when they drill down, the drill path should still match. Maybe share some screenshots if you are still…

@elicohen this looks like it is still an issue today. My "solution" has been to just use the navigation bar without utilizing drop down menus. I agree that the usefulness of this brick is limited by the drop down menus not being able to extend beyond the frame of the card.

@user045907 - Have you considered using dataset views to filter the data to only the rows you want to keep?

@random_user_098765 i may be missing something here, but I don’t think think I window function is needed. create a variable for the temperature threshold. Min temperature: Min(case when ‘temperature’>=variable then ‘temperature’ end) Do something similar for max. min time: Min(case when ‘temperature’>=variable then ‘time…

@Jones01 For some reason, the pivot table will only allow the "graph by" option if your date field is used for the rows, not the column.

I believe you can use the group by tile to use group_concat() if you do that by account it should work for you

you can specify the sort order in a MySQL ETL transform