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
Super 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
      Super 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.