Forum Discussion

MJDS's avatar
MJDS
Frequent Visitor
2 years ago

Merge rows on single id in Direct Query

Hi everyone,   The background I'm trying to build a performance management dashboard for a multi-stage customer complaints process.  The data comes from a case management/CRM system and is shared ...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Use a table visual

Add the case id

Add the Created column twice

Set the first to Min and the second to Max

MJDS's avatar
MJDS
Frequent Visitor
2 years ago

Thanks, is there a way I could also use this method in a clustered column visual?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    How would that look like?

    • MJDS's avatar
      MJDS
      Frequent Visitor
      2 years ago

      I was thinking an average of the allocation days in the y axis and then month from a date table linked to the created value in the model.