Forum Discussion

jcamilo1985's avatar
jcamilo1985
Helper III
5 years ago

the page filter doesn't work

Good night Specialists

I turn to you for help because I've tried to fix it on my own but I can't find a way out and the truth is frustrating.

I have the following data model

modelo_update.png

I strive to star model following the recommendations of many experts, however now I have difficulty getting the results I need for some data.

in the sales table Company each line represents a sale, in the size directory companies are all companies, some of them have no sale, therefore do not have a related fact in the company sales table

I need to get a graph that tells me by segment (field in the company directory table) and by director how many companies do not have sales, the result is as follows:

graficos.png

as noted I do not get the correct result, in addition in the table of the directory companies make an ABC pareto, nor is it filtering correctly with the page filters

I don't know what else to try, if anyone can help me, I appreciate any guidance before I go crazy.

data model