Answered via slack group.

@kcoughlan65 other than setting the total shadow to fff and turning off gridlines there doesn't seem to be an option for that.

@SaloniShah try using the alter column tile after the append to cast it into a date.

@damen can you just include AND LENGTH(CONCAT(`LOAN NUMBER`, '')) < 7

@kcoughlan65 Hi, I've mocked up some data and produced this using a nested bar chart. Within the general tab I selected these options which in mind sorts based on the totals of each code and then limits the chart to 10 items. Does this help resolve your issue?

I was going to post the other day but assumed it had been a long week and I just couldn't see it. Definitely gone for me.

@MichelleH thanks. I had a feeling that would be the case.

@Jackie96 have you had a look at the native period over period charts Domo provide?

I'll mark this as resolved and answer my own question as hopefully will be useful for others. To get this behaviour I choose a Grouped bar + line chart. My sales went on the Y axis value and then next part was important. The next series value was budget followed by %. Then to move the budget value onto the left scale I…

@GrantSmith thanks. Yes this resolved itself.

@jsr We are using domo everywhere and one of our customers likes to use their fiscal yeah but they also like to run things on calendar year but the default calendar year in domo is sun-sat which can't be changed.

agree. Being able to also choose which columns you want as total columns would be useful.

This needs to be addressed as our customers will all be exporting the charts to PDF and PowerPoint and the exports need to match what they are seeing on screen.

for anyone that has a similar problem I resolved this by still using the concept outlined by @GrantSmith but also added a Comparison date with the formula DATE(STR_TO_DATE(CONCAT('01-',MONTHNAME(`dt`),'-2019'), '%d-%M-%Y')) so I could compare any month to 2019.

@MarkSnodgrass thank you very much, that is great. We have been "stacking" the data to get prior year comparisons so far which means doing a case when period type = 'This year' then value.... in the beast modes (can mean lots of them and not very user friendly for our users) I'm wondering if I should just join it up onto…

@damen I would use a beast mode with something like case when instrument = 'first home' then `current income` else `qualified income` end

@GrantSmith I believe I have found a solution by rewriting the comparison date with a formula in my ETL. case when `Period Type` = 'LM' and DAYOFMONTH(`Report Date`) != DAYOFMONTH(`Comparison Date`) then ADDDATE(`Comparison Date`, 36500) else `Comparison Date` end I only have data for 1 month so difficult to test properly.…

@GrantSmith thanks. Looks like another bug fix request then 🙄

@MichelleH Thanks. So I have a field called Week Start Date in my data which does exactly what it says but the range selector control still shows the dates in between the weeks rather than 52 steps for the year. am i doing something wrong

@damen@jaeW_at_Onyx looks like we have custom roles for our embedded domo everywhere instances (via broker). I'll have a look but I'm not sure it provides a way for a user to remove only their own dashboards. Surely the functionality should be in the manage dashboards popup at the bottom left

@jaeW_at_Onyx sorry you are right So we are embedding domo into our own portal via an identity broker. Buzz isn't available mainly I think because you lose the grey top bar when embedding. The full instance is there so the buzz functionality should be available. I think there should perhaps be a dedicated topic for this…

@Mod can this be moved to dataflows please

A further improvement would be to allow variables to be referenced in things like table headers.

@user07980 if you need a hand let me know.

easiest way would be to join your data up to this posted by @GrantSmith https://dojo.domo.com/main/discussion/53481/a-more-flexible-way-to-do-period-over-period-comparisons#latest

@Joe_M I have experienced this as well so have decided to not use the native period over period controls. (Although they are very nice) @GrantSmith has posted a solution for this that allows for much greater control and flexibility.…

@Pau I think a horizontal faceted bar should do it

@Shanmugavel Use sum(`col2`)/sum(`col1`)

Hi @TammyMarinac We are in a similar position and have just started using domo and domo everywhere's whitelabeled solution. Would be great to connect 👍

@ST_-Superman-_ thanks, Yes I suppose we can hijack something like the employee id to represent a unique user id.