Help with gauge in table, please

[Anonymous]

Hi,

I want to make table of activities and show the progress of each group of activities.

Activities have unique ids (ActivityId) but are grouped by their name (ActivityName) and their status can be pending, started (ongoing) or completed. The status is stated by flags (flagIsStarted and flagIsCompleted), and each entry has its own line in the data, i.e. one line when it is started and one when it is completed.

I have calculated the number of total unique activities, the number of started and completed activities from the data and derived the number of activities in progress (started - completed), both in number and in percent.

My problem emerges as I try to add a gauge in the table showing the number of completed and ongoing in relation to the total number of activities in the group in different colours (green for completed, yellow for ongoing and red for not yet started). To me it seems like the numbers are added over the whole table in the graph, as I get the same values for gauges on all rows. The fact that if I select one group of activities it looks correct, but then I don't see the other ones.

I want the current progress status for each activity group.

For example, in the table below, Activity 1 should have been all yellow as both are started but none completed. Activity 3 should have been all red as none is started.

I have attached the example file.

Any ideas? 🙂

[Anonymous]

Ok, I see. The thing is that I, in that case, need  meters for both Completed and OnGoing activities, and I don't think it is possible either. It looks like I have to solve/visualize it without using a table.

Too bad since it would have been the best.

[Roop]

You can have the bar doing 2 things at the same time. I have added a comment to ensure clarity to the user. This will allow a multi-faceted delivery:

I also attach the QVW file so that you can review - All the figures may be wrong but it gives an idea as to what is possible.

Hope it helps

[Anonymous]

The tricky part is that I need to show three variables.

I think that will be a bit confusing as the number of Completed activities rise, the number of OnGoing activities will diminish. Thus the the background will be red when when work is progressing well.

I have settled for another solution now. But if someone has a solution to my initial queation I'd be more than happy to know about it.

Thank you all for your time and interest.