Forum Discussion

Drako3090's avatar
Drako3090
Regular Visitor
9 years ago
Solved

Cummulative Measure for Funnel

Hi everyone, I'm trying to build a measure of cummulative countby a field, to next build a Funnel chart.   My data look like this:     The column [R. Status N°] in the 'Resumen' tab shows ...
Need Help
  • Drako3090's avatar
    Drako3090
    9 years ago

    Vvelarde After I read this, I checked the model and see that I have a Double Directional relationship between the tables. After set it only Single Directional, the measure works as it have to. Many thanks for have replicated the model, if you didn't I would still be crushing my head for the solution.

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Drako3090

 

Hi, i reproduce your scenario and your formula and works fine. Maybe i miss something more.

 

Look

 

Resumen Table (in my case don't have ETAPA 4)

 

 

Etapas Table

 

 

Measure & Funnel

 

 

Let me know where is the difference in your model.

 

Victor

Lima - Peru

Drako3090's avatar
Drako3090
Regular Visitor
9 years ago

Vvelarde After I read this, I checked the model and see that I have a Double Directional relationship between the tables. After set it only Single Directional, the measure works as it have to. Many thanks for have replicated the model, if you didn't I would still be crushing my head for the solution.