NathanDorsch Member

Thanks. when I removed the last order (by each source) beastmodes, this worked. However, I have the following beastmodes for each source: Last CSR Order = case when `Order Src` like 'CSR' then max(`order_date`) end And when I include them, they seem to mess up the table... is there a way to fix that formula so the issue…

Magic ETL

Ahh... I didn't notice I had to add a column to the view... thanks

Wow... so they named two different charts the same name (not to mention the "bar line" chart which is a third type of chart). That's totally not confusing... lol. Thanks.

Okay... I switched to Line Bar. It looks the same... what do I do to create two Y-Axes?

is the bar line chart only for comparing against prior time periods? I was wanting to display two different metrics. So one would be the bar and the other would be the line (with two separate Y-Axes).

Coming back to this.... Seriously, how do I create a simple bar line chart???? This should be so simple, yet I cannot figure this out and I don't understand what you're referring to with the Compare To,.

I wish we would have just stuck with Power BI.... and maybe I need to go back to that tool.

Okay, nice! This is a huge gamechanger for me - I like to have a lot of filters on my dashboards and without the drop-down selector, my prior filters just take up too much real estate.... I just wanted to ensure I wasn't overlooking this new filter this whole time... 😦

Thanks guys, I'm still a little confused. Let's say I have a dataset with the following date fields: registration date, order date, shipping date, returned date. Each order is captured on one row with all 4 of these date fields. And these dates of course could cover a wide range of time for one particular value. Let's say…

As far as card loading, this (or any of the suggestions about reducing the size of datasets or beastmodes) wouldn't seem to have any impact. I actually created a skeleton data table with 8 rows by 5 columns and included MOM and YOY values I calculated - so I could just put them into Single Value cards. This had zero impact…

For clarification, I have 37 bar charts which provide high level metrics, which my boss wanted to see - similar to how another business unit is displaying theirs in Power BI. Because Domo isn't good with allowing me to incorporate YOY and MOM trends, I broke them out as separate cards along with summary performance cards.…

I removed quite a lot of data. In fact, I'd estimate I am now pulling in maybe 10% of the data with the views I was pulling in prior with the datasets.... yet no impact whatsoever.

Thanks guys!

I'm now working on another dataset with a similar issue... basically, I have a bunch of data for cumulative reviews on each product. However, if there were no reviews for a particular product on a specific date, my dataset will not show the cumulative review for that product.... so for example, I may have the following…

ughhh... I don't think this will be feasible with my dataset... it's massive with all sort of columns of data - so I'd have a ton of combinations to add..

I don't have specific records with 0... they're missing. So in my case, is there a way to address this (without injecting data with 0 for each day which I really don't want to do....)?

@MarkSnodgrass I think I got this figured out for the most part, but am currently hung up on the initial value... I'd like the summary to say 1,319,412 [arrow] -1% [arrow] -2% MOM. However, Domo is separating the value and the follow on YOY/MOM indicators... How do I get them on one line? And how can I have value format…

How do I accept? My clicking on Yes to the "Did this answer the question?"

@MarkSnodgrass and @GrantSmith You guys are killing it! Thank you. I'll take your correction of my formula, as that appears to work. I was strugglign to follow on the other suggestion... but probably my own mental limitation 😏

I tried this and it doesn't seem to be working... What might I be doing wrong here>? Date(concat( case when Month(`Date`) > 1 then Year(`Date`) when Month(`Date`) = 1 then Year(Date) - 1 end, '1', case when Month(`Date`) > 1 then Month(`Date`) - 1 when Month(`Date`) = 1 then 12 end ))

hmmm... that didn't quite work. I'm thinking what I could do though is create a beast mode that simply subtracts one month from each date... or better yet (since not all months have the same number of days), can I create a beastmode with the prior month to each date? I could then use this in the Time Period. So if the date…

Thanks... I got it to work, but it is displaying a "Warning: Not all the data is shown." message.. How do I get rid of that?

Yes, it persists outside of analyzer... I tried the options you suggested to no avail. I'll open a support ticket.

@MarkSnodgrass or @GrantSmith or anyone who can help.... I have spent several hours working on this and cannot figure this out! I couldn't seem to get the div style="float:left" working... then I tried '<div align=left>' and right... to no avail What am I doing wrong? There's got to be a way to do this... :-( Below is my…

@MarkSnodgrass I think I got this figured out for the most part, but am currently hung up on the initial value... I'd like the summary to say 1,319,412 [arrow] -1% [arrow] -2% MOM. However, Domo is separating the value and the follow on YOY/MOM indicators... How do I get them on one line? And how can I have value format…

Thank you. Can you share a screenshot of what this would look like on a card/dashbaord?

Thanks @MarkSnodgrass How do I adjust the text color? It only shows up as black (which doesn't show well on a dark black bar).

Also... it doesn't appear I have the option to adjust the text color.... the only option is to select the fill box, which doesn't look very asthetic.

So Domo isn't able to allow you to change the colors of the Y Axis to match their respective line or bar? That seems pretty basic... 🤨