Chips

domo

💎

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…

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…

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 @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

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.…