Chips Contributor

So you are more concerned with the way the values read. You want the Y axis to read this way, and then the lines/diff bar correspond to that? "2 minute 00 seconds" "1 minute 45 seconds" "1 minute 30 seconds" "1 minute 15 seconds" "1 minute 00 seconds" What values are currently in your 2018/9 Average Duration columns?…

Hi there, Based on what I am understanding here I would use the "Line + Stacked Bar" visualization. General Properties -> Series on Left Scale = 2 X AXIS = "Week Number" Y AXIS = "2018 Avg Call Length" SERIES (1) = "2019 Avg Call Length" SERIES (2) = "Difference" *Drag "2019 Avg Call Length" into SERIES position, then drag…

Hi there, Can you throw a screenshot on here? From what I glean from your initial prompt I would recommend either: 1. Changing to a Horizontal Bar + Line 2. Using the log scale Guessing you have already thought of those or for some reason they won't work, so the other thought I had is 3. Multiply the % rate at an order of…

When I first started as a client, we created 30 identical pages on which the individual cards had different filters. This was back in the pre-pdp days! So no, creating separate cards is not an option. @DanB, can you elaborate on the beastmode option (buckle up @dtysick, Dan is one smart guy)?

Just noticed the time stamp on your original post (6:00pm) so I am guessing you may be signed off for the day. My Dojo day shift is coming to a close so I wanted to circle back. Depending on the number of clients you want to track, the first and easiest option would be to have separate cards for each client and set the…

Morning @dtysick. Can you attach a screenshot of your current alert configuration? I would expect you to have the ability to execute an alert on a row level, but it sounds like you've already exhausted that option so want to see exactly what configuration is failing you.

Hi @user04285 welcome to the community, and to Domo. Magic ETL can be incredibly powerful, here are a few Magic tips that I think may be helpful in your situation: - Start simple/small, trying just running this as a simple join between two of your datasets before bringing in the third. Take care to note the differences…

I am not aware of a way to dyanmically change chart min/maxes. I have seen what you are describing accomplished in other gauges by normalizing pct to goal as an "out of 100%". Only catch, you would need to have the "Actual" and the "Goal" in your dataset to dynamically calculate them. Client A - Actual 72% Client A…

@Valiant, any luck doing the same with a summary number? If it isn't a different link for each line of a card, but rather one link for the entirety of the card?

You should be able to enter to separate macros in the same data label. I have done it before. For example %_SERIES_NAME %_VALUE would return "Name Value" You can add delimiters and spaces to break up the returns %_SERIES_NAME - %_VALUE would return "Name - Value" And can even add line breaks %_SERIES_NAME <br> %_VALUE…

Can you upload a screenshot of the card, and an example of your dataset? Not sure I am fully tracking, but am willing to try to help!

Only way I can think of in a card is to use the Bubble Chart (plotting individuals as points), but it wouldn't be too pretty, and it wouldn't have connective lines between the bubbles. Alternatively, Domo does have an interactive org chart as a part of individual profiles. Not sure if that would fit your needs here or not.

You are spot on, Domo's running total visual won't do this for you unfortunately. It just adds current month to previous months over and over again which is why your first month is right but it goes sideways from there. This is an inelegant solution, but I was able to get it to work using your example data. On a Grouped…

Hi @gav, Domo has built in YoY functionality, you will see Period over Period chart types in the Analyzer. I will assume you have tried that, and it hasn't quite accomplished what you need (I have had the same experience, completely understand). My recommendation would then be the following Beastmode approach (ultimately…

Hi @mrrm17, can you upload (or type out) a short example of your dataset and intended outcomes? You've done a great job of decribing it, it would help me to see examples using values to fully comprehend. 

#Math Love it! Let us know how it goes @cmarutzky wrote:I will need to test this but it also gave me a another idea to test. If I create a key on the lowest level detail (date_revenuecenter_daypart) then I should be able to sum the traffic column and then divide by count(distinct key)

If what @ST_-Superman-_ posted doesn't work, then I am happy to dig a little deeper. And sorry @cmarutzky for the delay in response, it looks like my last correspondence didn't post to the thread. But no excuses! Which item is our category on this dataset? And what level of date granularity is ideal? That is to say, as…

Good morning @Nick_Bertz, what other fields do we have at our disposal here? Count of products per?

You could certainly do a clean up via Magic ETL, thinking you would join to a static "Clean Up" Excel doc that would have all the different incorrect states State S/B CA CA ca CA cal CA But the first thing I would do is look for other fields in your query that could help, that might be more reliable. Do you have zip code…

Good morning @cmarutzky, can you share a screenshot or upload an example of the dataset? And how are you wanting to use the aggregations? Summary number? Data label? cg

I think you may need to wrap all of your conditionals in the same html concat instead of individually Something like CONCAT( '<div style="background-color:transparent; color:#ff0505; font-weight:bold; width: 100%; height:100%; margin-right:10px; padding:20px;">', WHEN ((COUNT(CASE WHEN `Analyzer_Domo_Property__c` =…

Hi there, I am out of my league in completely understanding the impact of your requirement for binary, but I would restate your volumes of bytes using a Beast Mode that calculates and concatenates. -------------------------------------- CASE WHEN 'Bytes' < 1048576 THEN concat(round( 'Bytes' / 1024,0),' KB') WHEN 'Bytes'…

NOT A FULLY BAKED SOLUTION BUT... I once saw something similar solved in Excel by creating two series of data. 1. Your Green, continuous 2. Your Red, conditionally shown only when value was below the threshold If the goal is > 10 Green - 8, 7, 11, 13, 9 Red - 8, 7, null, null, 9 The red would "show up" and "cover up" green…

Two alternatives you might consider: 1. Line + Nested Bar Visual Use the Line as your count The line can be a little confusing to your business user, as it usually implicates time. So you could also do 2. Symbol + Grouped Bar Visual Use the Symbol as your count Realize this too is imperfect given your intention bc they are…

Understood, and for that I am unaware of a beast mode solution. I could envision a Magic ETL solution whereby you effectively create columns for each date and evaluate if someone was employed and if the program was active. So in your example you would write columns to your dataset for 11/10, 11/11 etc and then do…

I do not believe this exact chart type exists. Your next best bet is Line + Stacked Bar (or Line + Grouped Bar). Note: The Line in your dataset will always be the First Data Type in your data, so you might need to add a Data Type sort. 

I am not aware of a setting that allows customizable angles for labels. I have though used a horizontal bar chart and Data Labels to accomplish something similar by using the %_Category_Name (at least based on your example I think it would be "Category") macro as the Data Label Text for the different data points.…

Can you give a little more detail with your question? What does your data look like? And what do the axies currently show?

Seems like there may be a (complicated albeit) CASE logic statement to be created here. Is your data structured in a such a way where all the fields you've outlined could be considered (could aggregate if needed) simultaneously? *Note have just typed this here in Dojo, haven't validated, but to illustrate my thought:…

Sorry for the delayed response @TrentB, I have tried to approach this a couple of different ways using only beastmode and am unable to come up with a viable solution. I think you have two options: 1. Use a dataflow to tag each account with a "Month of First Invoice", then use that field as a Series in a multi-line card 2.…