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

LMS · February 2021

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

Monthly Total Sales & Price Per Unit.PNG

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 · February 2021

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 · February 2021

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 · February 2021

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 · February 2021

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

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

Answers

Categories