Point it at your own CSV export and every calculation is already written: a Tableau consultant bills 110-150 USD per hour and a starter dashboard is quoted at 10-16 hours.
Formula: SUM([Revenue]) - SUM([Cost])
Uses: Revenue, Cost
Formula: ZN(SUM([Revenue]) - SUM([Cost])) / SUM([Revenue])
Uses: Revenue, Cost
Formula: ZN(SUM([Revenue])) / SUM([Quota])
Uses: Revenue, Quota
Formula: SUM([Revenue]) / COUNTD([Product])
Uses: Revenue, Product
Formula: IF ZN(SUM([Revenue])) < SUM([Quota]) THEN 'Behind' ELSE 'On track' END
Uses: Revenue, Quota
| Column | Type | Role |
|---|---|---|
Order Date | date | dimension |
Region | string | dimension |
Rep | string | dimension |
Product | string | dimension |
Units | integer | measure |
Revenue | real | measure |
Cost | real | measure |
Quota | real | measure |
Order Date,Region,Rep,Product,Units,Revenue,Cost,Quota
File you connect: sales-export.csv
This page is the working piece. The full pack has everything below.
Point it at your own CSV export and every calculation is already written: a Tableau consultant bills 110-150 USD per hour and a starter dashboard is quoted at 10-16 hours.
A freelance Tableau consultant charges 110-150 USD per hour; a starter sales dashboard is quoted at 10-16 hours.
Send it to me