% of Total Sales Column Add

leonardschlemm · February 2021

Hello All,

New to Domo and appreciate the community support.

I have a table card that includes net sales by cashier listed for the day in descending order. I would like to add a column that shows their sales as a % of total sales for the day.

How would I do this ?

Thanks !

jaeW_at_Onyx · February 2021

@leonardschlemm , what @swagner gave you is called a window function. this is a common implementation in SQL which can be googled!

assuming you have cashiers on the axis, you should be getting that cashiers sales as a percent of total sales.

if you want that cashiers sales as a percent of store sales or some other subtotal method, add a partition by clause.

sum(sum(amount)) over (partition by `store`)

I have a couple videos on my channel on the topic.

https://www.youtube.com/watch?v=eifSYZIcPzg&t=504s

https://www.youtube.com/watch?v=ZPf41Fjn1H8&t=410s

swagner · February 2021

Try this:

If the Sales beast mode is SUM(`Sales`), then the % of Sales beast mode would be:

SUM(`Sales`) / SUM(SUM(`Sales`)) OVER()

leonardschlemm · February 2021

thanks for quick response. how would i reference the cashier in this function ? the cashier data line is a dimension

jaeW_at_Onyx · February 2021

@leonardschlemm , what @swagner gave you is called a window function. this is a common implementation in SQL which can be googled!

assuming you have cashiers on the axis, you should be getting that cashiers sales as a percent of total sales.

if you want that cashiers sales as a percent of store sales or some other subtotal method, add a partition by clause.

sum(sum(amount)) over (partition by `store`)

I have a couple videos on my channel on the topic.

https://www.youtube.com/watch?v=eifSYZIcPzg&t=504s

https://www.youtube.com/watch?v=ZPf41Fjn1H8&t=410s

leonardschlemm · February 2021

Thanks !

Magic ETL

Magic ETL

% of Total Sales Column Add

Welcome!

Best Answer

Answers

Welcome!

Welcome!

Quick Links

Categories