Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Show Percentages of crosstab column Total? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Show Percentages of crosstab column Total?

Received Response
21
Views
2
Comments
edited Apr 16, 2020 3:37PM in Reporting & Analytics for B2C Service 2 comments

Summary

Need help creating a view that show trending over time (daily, weekly etc) in the % split of our Product IDs..

Content

I know this is possible but seem to be unable to build myself, and but have spent forever searching this forum without luck:   

Goal:  We want to create a simple chart that presents the ongoing daily trend of the % split of our incidents by product.   

It's easy to produce this with the absolute numbers:  Columns are: DateGroup "Interval", Product ID, and Count of Incidents Created.   Then I set up a cross tab with "Product ID" as the Row Field,  "Interval" as Column field, and "Incidents Created" as the output field.    This provides a chart showing the daily trend of our incident volumes by each Product.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!