Charlie Bantoft Member

Yeah - thanks, Mark. There are so many combinations of columns I'd need to create and unfortunately it's infinite given the data I'm ingesting daily. I was hoping there'd be something similar to FIXED BY FILTER DENY etc. that you could apply to the x-axis. Thanks anyway.

Is it possible to get the x-axis of bar charts to ignore filters too? I have 15 business units and when I filter data, some of those business units are filtered out but I still want them to show on the x-axis of the bar chart. Thanks

Great. That's worked. Thank you Michelle & Grant.

Thank you, Michelle. What goes in the place of 'Dimension', please ? I just want to sum all revenue - not filtered by any given dimension. Thanks again.

Hi @michelleH - thanks for your responses. I can't seem to get total rows and columns to use the same aggregation and I've tried your formula (thank you) but it's still not right (same result as before actually). I'll tinker around with it. Thanks again.

This is been very useful by the way @rco. Thank you very much indeed.

Thanks very much indeed @rco - going to try this shortly. Will let you know how I get on. Really appreciate it.

Thank you! Once I have this column sorted @rco how would you advise filtering on its results with an in-dashboard filter? so, for example: if a row has the data string 'Volvo, Porsche, Austin' and I want to filter all rows that 'contain' 'Porsche' using a drop down that has all car manufacturers on it - how would I do…

Thanks @GrantSmith I've got that flow but am having trouble with the configuration somewhere. I'll continue to play around with it - I'm on the right track. Thanks very much indeed.

Thanks both. @jessdoe I love this idea and it'll work for other problems I have but not this one. Thanks anyway. @GrantSmith I think I follow but could you give me a little more detail please? Thanks so much.

Is this still an issue? I'm relatively new to Domo and amazed this isn't easier. It could be achieved in the 'Group By' tile. There's already 'Combine strings separated by ,' Could @domo add 'Combine unique strings separated by ,' ?

Hi Marcel. Thanks so much for thinking hard about this. It's been a public holiday today in the UK so I'm only just looking at it this evening and can see I need tomorrow morning's fresh eyes (and mind on it). I think I understand what you're doing though and that does seem the simplest solution. I'll wrap my head around…

Yeah - I've seen that option. How many would I need if I want to give dashboard users the option to do 7day, 30day, 90day, 180day and 360day rolling averages? 5? Also: with your earlier solution and with the Rank & Window option, would it matter if days (typically Saturdays and Sundays) are missing? Thank you, again.

Can you put a variable inside the %s? So: CASE WHEN fieldname LIKE '%'variable a'%' THEN 'Self-Service' ELSE 'Something else'

Thanks so much, Mark. I had wanted to let users slide from 7 to 365 but I'll have to do it in pretty large steps otherwise I'll be writing that out until Christmas! I can't believe there isn't an ETL solution or beast mode that's easier. Crazy as it's something most people want to see. Thanks again. Charlie

Thanks Grant. Appreciate the quick response: You first option only works if the user knows what value option to use and they won't always know The second option ends up returning the same person several times if (for example) they speak French, German and Russian and the values entered were 'French', 'German' and…