- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
just an idea, don‘t know if it works (because i can‘t test it)
1) create a table with metrics „revenue“ and „discount“, broken down by dimension „order ID“
2) create a new calculated metric „discount %“ with formula {„discount“ / „revenue“ * 100}
and add it to the table. it should show the discount percentage for each order ...
3) create a new calculated metric „discount exceeds revenue“ with formula
{ if (“discount %“ greater than “100“) then “1“ else „0“}
and add it to the table. it should show a „1“ for each order where „discount“ is greater than revenue
4) create a new calculated meteic where you sum up the values of the last added column. formula is like
{column sum „discount exceeds revenue“}
and add it to the table. in every field it will show you the total of orders where the discount exceeded the revenue.
i don‘t know if you can create an alert out of this last metric...
but now you can add other calculations, eg. divide the last calc. metric by the total of orders (approx distinct count „orders“) to get a percentage value.
by using „number visualization„ and hiding the table you have at least a cool number for a dashboard
perfectdashboard.rocks
Views
Replies
Total Likes