Forum Discussion

Daniel_playford's avatar
Daniel_playford
Regular Visitor
5 years ago

Show most recent data for different dates

Hello,   I have a dataset which keeps track of when people report issues and which issues they reported. A 0 code means no problem.    People can report several issues at a time and they get ente...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

you may want to play with more visualizations.  Oftentimes graphical solutions are sufficient

 

 

What decision are you trying to support with your report?

Daniel_playford's avatar
Daniel_playford
Regular Visitor
5 years ago

Thanks for the reply,

 

The goal is to get insight into the prevalence of different issues in the past. You could see the code as users and the different codes as qualitative feedback and then coded into one of several issue codes. The goal is to be able to see for example the 4th of April how many of each issue code was “active”, and this for every date.

 

With the graph and then issues code as problem you get this:

But this just shows an always increasing amout of issues. 

Below graph shows that per ID there is only 1 data point. While there should be 4 showing the amount of issues for every date that the ID has one.