-
Re: YOY count
Try doing this as a different way to count without using the count aggregation inside the sum aggregation. SUM(CASE WHEN YEAR(`time_stamp`) = YEAR(CURRENT_DATE()) THEN 1 ELSE 0 END) / SUM(CASE WHEN Y…1 -
Re: Making a bucket list of defects
For the OR statement, you need to restate the field you are comparing against like this: WHEN `ComplaintDesc` LIKE '%ICE%' OR `ComplaintDesc` LIKE '% ICE%' THEN 'ICE'1 -
Re: Can't Graph by Month
@SaloniShah A couple things to point out here: Your x-axis is not being recognized as a date field. When it isn't a date field, Domo will not let you use the "graph by" option in the d…1 -
Re: How can I edit this card to only show one column's data label?
In your Data Label Settings, set Show Datalabels On to Lines Only.2 -
Re: How do I format?
You can keep your y-axis as count, but change your chart type to the 100% stacked bar. It is found under the vertical bar chart type. This will get your items to add up to a 100%.3

