How to build acard to show breakdown of revenue by Margin % on transactions

Jobur
Jobur Ireland ⚪️

Hi,

I would like to build a card to show how much revenue is generated by sales at different margin % bands.

Is there an easy way to accomplish this? I think I could add a column to the dataset (already over 100 columns) to categorize each transaction. Is there another way to approach this?

I have a Revenue dataset with hundreds of different product types.

Each record has the customer, product, date, sales revenue, cost, Margin & Margin % on it.

What I would like to do is display visually how much of the revenue is generated from sales from each margin band: < 25%; 25% - 50%; 50% - 75%; 75% - 100%

If we had 1m in sales in a month, you could see how much has a margin of < 25%, 25% - 50%...

Thanks

John

PS is the slack domousergroup still open, how do I get an invite to this.

Best Answers

Answers

  • Jobur
    Jobur Ireland ⚪️

    Thanks Grant - I knew there had to be an easier way to do it. 😀

    Do you know if there is a domouser slack channel? I think I saw it mentioned on the forum before