Static data gets weird when date added

[Nikit18]

Hello, I have an issue. 

There is static table in visual displaying values for each Day of the week, i.e Mon, Tue, Wed etc. These number are accurate before I add dates. 

The moment dates were added the static values goes multiple times higher. 

Due to this issue I'm unable to display daily static values. Can someone suggest if this can be solved. 

@amitchandak  Please let me know if you can suggest solution 

[lbendlin · Accepted solution]

Consider using a matrix visual with dynamic columns.

Validate your data model and eliminate connection gaps.

[Nikit18]

Thank you it worked.