Forum Discussion
Need help getting certain values from a specific related table
It seems like you have everything you need on the availability table.
You could use a matrix visualization (or Pivot Table, in Excel), and place [date_hour] on rows, [machine] on columns, [availability_%] on values and slice by date (I am guessing you have a date field in there too), you could get the table you described. No need to create a new table.
It's true that I have everything I need on that table. But the reason I am trying to do it this way is for plotting graphs. Unless I am misunderstanding you, I don't think that can be done with what you described (at least not the kind of graphs I want to have).
I already have some graphs. The first one shows the date on the x-axis with the total duration of machine downtimes on the y-axis, then you can drill through for a specific date and see the downtime durations for every hour of the day for a specific date. My goal is to change that second graph into a line and clustered column chart where the column values remains the same as it was before (total downtime duration for all machines) and there are individual lines for each specific machine representing their availability %.
But if I can't figure out how to do what I'm trying to do, I'll consider your suggestion!
