Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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? 🙂
Hi Erik,
I think I understand your problem.
You're trying to make the colours dynamic line by line and that's not how this chart works. These properties are set across the whole chart.
Richard
Hi Richard,
Yes, that is exactly what I want. If that is not a possible way forward, are there any other ways to achieve the same effect?
BR,
Erik
I think that this is what is required. You need to set the rule in the expression and then define the guage - See if you like it
Rupert
Thanks for your reply, Rupert, but that is not what I want to achieve.
How about this ....
You save a column of data by colouring the activities .....
Hi,
You can See attached QVW.
A better example:
Thank you, Krishnama, but I don't quite see what you mean.
Hi,
What you require from me. I also sent QVW . You do not keep expression in Gauge Properties. you can see attachment.