Previous General Totara Learn discussions (read only)

Totara 2.9 Pie Data Sources

I can select various data sources in the report graph type column but in the report graph type pie I can only select one source (cf. picture)

is there a way to select various data sources in the report graph pie?

thank you

Permalink | Reply

Hi LV

I think this is by design - a pie chart only uses one data series and shows the amount compared to the total for the data series.

regards

Permalink | Show parent | Reply

Thank you Craig

So how can I do to build a report to obtain a pie like this one (cf. image) based on the Program Completion Source (or maybe based on other source) with this datas: is complete, is not started and in progress ?

Permalink | Show parent | Reply

Hi Laurent,

You can do this by creating a report using course completition source.

You could set columns such as course name, is complete, is in progress and is not yet started.

Best regards,

Jussi

Permalink | Show parent | Reply

Sorry, should read the thread before answering - just noticed that this was already the path you have discussed with Craig - and the problem is the pie chart. Well, interesting to see what Craig says but you can illustrate the information you intended with the totara "stack" chart.

However, I must admit we use excel for all reporting mainly because we cannot use our organisation information. Our stucture is longer than hundred characters.

Permalink | Show parent | Reply

Thank you, Jussi I've made some good stacked column graphs but in our office we like pie charts too.

Permalink | Show parent | Reply

Thanks for raising this issue. Graphs are interesting for us too even we are not activile using them.

In many cases we would like to filter the results and prevent the user to access anything else but his/her slice of organisation data.

How do you make the graph available in your office?

Best regards,

Jussi

Permalink | Show parent | Reply

Well that's our next step; filters and access!

We are building this graphs for our managers using their specific dashboard, but we are starting with that stuff and still thinking about.

regards

laurent

Permalink | Show parent | Reply

Hello Laurent,

Thanks for your reply.

Have you tried report graph block with saved (scheduled) report?

It would be great to learn from your experiences - we have so little time for Totara admin work and so many promising ideas to look at. If you want to discuss confidentially you can mail me jussi.tuominen@adlearning.com

Best regards,

Jussi

Permalink | Show parent | Reply

No we have not tried report graph block with saved (scheduled) report. It sounds good. I'll try this week

Permalink | Show parent | Reply

Hi,

Here's just a quick example how to add this as report graph block into manager's dashboard.

1. When you have first created report and report pie graph, then go to Content tab:

Select Content Controls > "Any" or "All" - depending on your reporting needs.

Depending on your needs, select here Show by the user's current organisation...

...or Show by the user:

You can also add more controls e.g. "Show records based on the completion date" > "The current financial year".

Save changes.

2. Then go to Access tab and select role(s) - here I just select Staff manager. Save changes.

3. Go to Dashboard and add Report graph block, then select report & save.

4. Login as a manager - use a test account with direct reports or use Login as User. Here's what it looks like:

Cheers,

Jani

Permalink | Show parent | Reply

Hi Laurent,

Here's example:

Report source: program completion.

1. Set report Columns as shown below...

2 ...and graph settings:

Result is here - note there is User's Organisation as a Filter.

Regards,

Jani

Permalink | Show parent | Reply

Great! I'm using so "user id number" + "count unique" instead of "user fullname" it works great thank you

missed this "status" field

Thanks!

Permalink | Show parent | Reply

This is good stuff - thanks Jani!

Permalink | Show parent | Reply

Hi Laurent,

I've taken the liberty of upgrading your self-registered Totara Community account to that of a Subscriber.