Frequency Over Time Chart Type

sdarmody

Hi, does anyone know of a way to create a chart that looks like the attached? Custom chart? I want to use a chart like this to represent the # of tech support incidents getting created over time. I know a line chart could work. I like how this chart categorizes them in bands. 0-10, 10-100, 100-1000, etc.

GrantSmith

Hi @sdarmody 

 

The closest chart would be the Flex Table however it doesn't support the heatmap banding that you're wanting. You'll likely need to create a customer chart for this specific use case.

MarkSnodgrass

@sdarmody You might be able to pull this off with a Heat Map card. Here is a basic example. Use your date for category 1, your count of tech support incidents for the value, and then a company name or something that doesn't have multiple values for category 2 so that your don't have multiple rows. You could create a beast mode with a hard-coded value if you don't have anything. In the Date Range filter, choose to Graph by Day. You can then use the heatmap options to control the coloring, etc...

jaeW_at_Onyx

If you like the idea of grouping data into bands ... why don't you just group the data into bands?

 

case when sum amount < 100 then .. 

when sum(amount) < 200 then ...

when sum(amount) < 1000 then ..

else ...

end