miguel_bustamante Member

@MarkSnodgrass Thank you so much that is a much better solution

I figured it out, I set a filter to the last month available within the actual card. Not great but better than nothing. Open to other suggestions, as of right now it wont let me look at unit counts in other months without breaking it.

@DavidChurchman So the difference between the two is the Units data set only has one entry per facility, it does not have to worry about the time filter like the states card does. I know why they are different, but I can not normalize that as I need to keep the months filter working on the states card, but not the units…

That method didnt work, but it did give me an idea that did. I was overthinking it. Instead of making the unit types as headers I made them their own column and then used a quick filter to only show the rows that matched the specific unit types i wanted.

this is awesome thank you so much

thank you, sorry im so inexperienced hahaha

@GrantSmith How would I do that? What does that even mean? Coalesce is not a function in beastmodes. Assume Im very new to beastmodes cause your answer feels like you just restated my question as a statement hahaha. Thats what im trying to do, if I knew how to do it I wouldnt have posted this lol.

I just made it into two charts, but was really hoping to find a way to do just one. DOMO should really implement a way to due this naturally. Such a handicap to beastmodes that this cant be done.

How do i do the custom number formating… I looked through all the value scale options and number format options, not a single one lets me control the way that the data is displayed on a case by case basis they are all explicit formating. Explicit formating is not what I need because I need them to be different, thats the…

@ArborRose Looking at it, the data table is showing it as a percentage, but it is not carrying over to the actual chart.

@ArborRose This did not do anything. Is there maybe a change in my chart properties that could be causing this? Only properties I have set is Show total labels selected. and both Value Scale (y) and Category Scale (x) Titles set.

I think the best way to do that would be to do a dual line period over period graph Ik you said thats not what you want but hear me out. You arent comparing this period to last period, you are comparing your this period over last period to their this period over last period. So it effectively becomes your gross…