ST_Superman Domo Employee

@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

Another option for drilling down to charts might be to have the default behavior of the color rule only apply to the single column and not the entire row.

I'm not sure this counts as an idea since it has already been announced. But I'll upvote because I am excited about the feature

@faisalnjit - I don't believe the no data handling will apply here. That would only impact a filter selection with no values. If you are always comparing YTD sales to the prior year, I would consider using the "Multi-value Columns" chart. You can then create two calculated fields: YTD Sales SUM(CASE WHEN YEAR(`Date`) =…

You can change the dates based on presets… not sure if you can change the graph by options with a filter card though. Maybe a feature request?

I want to color the dashboard header I would like to be able to color the dashboard header. Right now I'm making another card just to add color, but I want to reduce the number of cards as much as possible.

Translation: I want to group DataSet item names On the analyzer screen, I think the items are divided into "dimension" and "measurement", but I would like to group these contents. I want to place related items such as dates, products, and customers in the same order, but currently they are in order of name, so I am…

@Mirnes - I'm having difficulty understanding what you are asking. The solution that @MarkSnodgrass provided should give you a new field containing all of the first words from your original field of | separated values. Per the image provide, if you place that field as your series in the graph, it should provide you with…

@Patrick_Cruz - I'm not sure of a way to accomplish this. I believe this would need to be a feature request. There may be a way to accomplish this kind of labeling using a DDX brick, but I don't have the coding skills to help you there.

@Jacinta correct. When the date diff is less than 30 it will use qty value and if greater than 30 it will use 0. It will then sum all the values.

It seems like you should be able to just use COUNT(DISTINCT `idcontent`) Then you can set that value as a filter and select >5 or >100, whatever you want to filter for. Then, just include UserId and Name in the table.

sum(case when DATEDIFF(CURDATE(),`Calendar Date`) < = 30 then `Qty` else 0 end)

@Yoon2020 You just need to split up your ROUND((SUM(`impressions`)),0) It's already inside of a CONCAT(), so you need to separate the thousands from the hundreds. Try putting this instead ROUND(SUM(`impressions`)/1000,0),',',MOD(SUM(`impressions`),1000) This will not add a second comma if you exceed 999,999 impressions…

@andresperezfc - The general formula for a window function in Domo would look something like this: SUM(SUM( `fieldName` )) OVER (PARTITION BY `seriesName`) You can allso use FIXED functions SUM(SUM( `fieldName` )) FIXED (BY `seriesName`) That being said, you generally want to try to avoid nesting window functions within a…