Forum Discussion
Solved
Creating a Cumulative Histogram
Hi Everyone, I was wondering if anyone could help me create the following visualization Y axis = number of tickets X axis = Age of tickets Days Specifically I need help either creating ...
Ok to achieve this we need an AGE table, which simply has a column called "Age(Days)" with a unique values from 1 to the number of days you want in the graph. Link this to Table1 in your table relationships.
Create this measure:
Cumulative Measure = VAR currentAge = max(Age[Age (Days)]) RETURN CALCULATE( COUNTROWS(Table1), ALL(Table1), Table1[Age (days)] > currentAge )
Create a line graph using these settings:
Axis - 'Age'[Age(Days)]
Values - The measure we created
You'll get this:
Ok to achieve this we need an AGE table, which simply has a column called "Age(Days)" with a unique values from 1 to the number of days you want in the graph. Link this to Table1 in your table relationships.
Create this measure:
Cumulative Measure = VAR currentAge = max(Age[Age (Days)])
RETURN
CALCULATE(
COUNTROWS(Table1),
ALL(Table1),
Table1[Age (days)] > currentAge
)
Create a line graph using these settings:
Axis - 'Age'[Age(Days)]
Values - The measure we created
You'll get this: