0

Level based matric trend chart

Hi,

I have a requirement to build level based matric trend chart, below is the scenario

Data

INVOICE_ID CLEAN_WEIGHT Date
inv1 Valid 10/1/2020
inv2 Not Valid 10/2/2020
inv3 Valid 10/3/2020
inv4 Not Valid 10/4/2020
inv5 Valid 10/5/2020
inv6 Valid 10/6/2020
inv7 Not Valid 10/7/2020
inv8 Valid 10/8/2020
inv9 Not Valid 10/9/2020
inv10 Valid 10/10/2020
inv11 Valid 10/11/2020
inv12 Not Valid 10/12/2020
inv13 Valid 10/13/2020
inv14 Valid 10/14/2020
inv15 Not Valid 10/15/2020
inv16 Not Valid 10/16/2020
inv17 Not Valid 10/17/2020
inv18 Not Valid

10/18/2020

I am able to achieve my requirement in Aggregate Table, but how do I convert it to Trend chart on year with Percentages

 

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 2 wk agoLast active
  • 2Replies
  • 13Views
  • 2 Following

Product Announcement


We are happy to
announce Incorta 4.8 !!!