Best Of
Re: Centering a Summary Number
The center tag here is referring to the column alignment option in 'Format', right?
amehdad
Re: Assembler Upsert Date Column
Answers are in other thread: https://dojo.domo.com/discussion/53474/assembler-upsert-date-column#latest
amehdad
Re: What TYPE of post should I make?
This has to be mandatory reading for every new user or returning users after a long absence.
amehdad
Re: First Ever Virtual Community Awards Ceremony
Following event after the next for APAC? 👀
amehdad
Re: Value Average returning incorrect average when filtering?
Hi @ibtisamyyy, could you please share your calculations for that 'Percentile Ranking'?
amehdad
Re: How to indicate the values of two columns on Y axis
Hi @eriena, the 'Curved Line + Stacked Bar' should enable you to see values for each column (based on how many 'Measures' you drag into the Series section). To have the values appear, see the image below to enable that setting:
Please provide more information if you are after something else.
amehdad
Re: How to calculate a ratio like 2:1
You can use the formula tile and the concatenate function to build your ratio string like this:
CONCAT(`Usedfield`,':',`Newfield`)
This would build your string.
Re: How to calculate a ratio like 2:1
@robdmitchell Also to build on what @MarkSnodgrass posted, if you have unusual ratios (216:81), then you could do the following:
CONCAT(SUM('UsedField')/SUM('NewField'),' : ','1')
This would always give you the number of used for one new.
Re: Count number of character occurrence in string
You can calculate the length of the string, remove the character you want, recalculate the length and take the difference.
LENGTH(`Color`) - LENGTH(REPLACE(`Color`, ',', '')) + 1
