lawiti Member

@MarkSnodgrass How can I swap the two axes, I want the percent on the right and the count on the left

Thank you very much !

@GrantSmith do you have further guidance on this?

@GrantSmith, thanks for your response. I will give you an example with the 3. SUM(chemcost/day)/ SUM(AVG BBLs)…the chemcost/day = SUM(COALESCE(Ferric_cost, 0)) + SUM(COALESCE(FEP_cost, 0)) + SUM(COALESCE(HP_cost, 0)) + SUM(COALESCE(SES_Poly_cost, 0)) + SUM(COALESCE(Innospec_cost, 0)) + SUM(COALESCE(PAC_cost, 0)). AVG BBLs…

@MichelleH , yes.Thank you!!

@MichelleH , thank you for you response,so Domo does not keep a log of changes for me😊?

@MarkSnodgrass thank you, it worked.

@MichelleH , that works.Thank you!!

@MichelleH , I have done that, but it seems I won't be able to use the line chart anymore?

@MichelleH Thank you for the suggestion, I tried this SUM(CASE WHEN `Segment` = 'A' THEN `Hires` WHEN `Segment` = 'B' THEN `Hires` WHEN `Segment` = 'C' THEN `Hires` WHEN `Segment` = 'D' THEN `Hires` WHEN `Segment` = 'E' THEN `Hires` ELSE 0 END) But still not showing the zeros, I have checked my data label setting, show…

I tried this, IFNULL(SUM(Hires), 0), still not showing the zeros

@pauljames , thanks, I switched to grouped bar charts but still not showing the zeros, the data is a bit sensitive so I might not share here.

@pauljames I have it selected but still not showing the zeros on the chart

Thank you all for your responses, very insightful.

Thanks @GrantSmith

Thanks, @GrantSmith This is very helpful!

Thanks, @GrantSmith and @MarkSnodgrass , it's working.

@GrantSmith , thanks for your suggestion. Let me give more context, Tables A and B are very similar, they both have exact same attributes and records the only thing changing from time to time is the date on on the records, essentially I would like to single out the records whenever the date changes/gets updated. So a full…