How to make a Monthly Total Sales & Price Per Unit and Summary Table With Corrected Color

LMS

Hi there,

Since I'm a beginner user in DOMO, therefore I need helps to create 2 cards as below:

1st Card:

• Monthly Total Sales & Price Per Unit (Bar and Line Chart)
• Green Bar: Monthly Total Sales in Product Grape
• Line Chart: Unit Price of Product Grape

2nd Card

• Table card with exactly background and words color.
• Header of Table also must be exactly same

Please assist me as soon as possible, this is very urgent, I'm very sorry for the inconvenienced caused.

I attached the raw data to create this 2 card as well.

RawData.xlsx

DomoFaye

Not sure how you calculate a unit price since it is not provided in the raw data. Asking the owner of the cards to share the cards with you might be the easiest approach.

Otherwise, the links below will be helpful for building bar chart and table chart: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Bar_Chart

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Pivot_Table

DomoFaye

Not sure how you calculate a unit price since it is not provided in the raw data. Asking the owner of the cards to share the cards with you might be the easiest approach.

Otherwise, the links below will be helpful for building bar chart and table chart: https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Bar_Chart

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Building_Each_Chart_Type/Pivot_Table

jaeW_at_Onyx

you cannot set background colors on header columns and rows.

in the standard table chart type, you can apply HTML formatting to your beast modes, https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Adding_Graphics%2C_Links%2C_and_Images_to_Table_Cards_Using_Beast_Mode

@LMS it seems like you could benefit from the resources at, https://learndomo.domo.com. there's a ton of free training there.

LMS

Thank you for the suggested card building, although this is not the card i wanted, but i will try to figure out myself.