Forum Discussion

Tim_H's avatar
Tim_H
Icon for Helper I rankHelper I
5 years ago
Solved

How to create percentage trendline ?

Hi,   I want to create a percentage trendline for all closed tickets in time   I already created two tables in XLS to count tickets per day   DaysTicket # 0 3 3 1 7 1 9 1 11...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Tim_H 

    Please correct me if I wrongly understood.

     

    please check the below picture whether it is what you need. 

     

    total quantity cumulate =
    CALCULATE( [total quantity], FILTER(
    ALLSELECTED(Days_Table), Days_Table[Days] <= MAX( Days_Table[Days])))
     
     
    PBIX file link is down below.

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Tim_H 

Please correct me if I wrongly understood.

 

please check the below picture whether it is what you need. 

 

total quantity cumulate =
CALCULATE( [total quantity], FILTER(
ALLSELECTED(Days_Table), Days_Table[Days] <= MAX( Days_Table[Days])))
 
 
PBIX file link is down below.

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

 

 

Tim_H's avatar
Tim_H
Icon for Helper I rankHelper I
5 years ago

This is in the way I want it...only I have a calculation before I came to the tables shown above.

 

for example: I use below calculation to get tickets per day

 

_Final_sol_time tickets age grouping = COUNTROWS(FILTER(overview, overview[Case Milestone_Final Sol Actual Elapsed Time]>=VALUES('Hours Grouping'[min])&& overview[Case Milestone_Final Sol Actual Elapsed Time]<=VALUES('Hours Grouping'[max])))
 
This gives me below
 

 

blue flat line is KPI
 
it is on this graph I want to add the cumulative percentage.
 
 
 
kr
 
Tim H
  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi, Tim_H 

    Thank you for your information.

    Is it OK with you to share your sample data?

    It helps me a lot to look into it with a clear idea.

    Thank you very much.

    • Tim_H's avatar
      Tim_H
      Icon for Helper I rankHelper I
      5 years ago

      I have to see how to create a sample from the whole pibx..current PIBX has +400k lines and +200 columns wit some restricted data (GDPR).