Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
On the attached application were trying to visually show the informtion within the table. The table shows arrears at certain points which have either increased or decreased. It would be great to show this as line or bar chrat so you could better see the difference.
Can anybody help?
Kind regards
Chris
Hi Chris,
to build a barchart, you usually need a master_calendar - but in this instance, you don't have data for every day, do you?
Well, you can still use a master_calendar with 365 days and link your data_table to that. Just edit the dimension (with a formula) to just include the days when you have data for arrears - you could to create a binary field for that.
With a multi_chart (essentially a barchart where you can include lines) you can essentially show whatever you like.
HTH
Best regards,
DataNibbler
P.S.: It seems a good idea to put your master_calendar in a qvs file since you are likely to need that in other apps you're going to build in the future. Then you can simply INCLUDE that and you won't have any potential for differences and errors.
Hi,
when you load the excel file it is better if you transform the excel pivot in a table, adding the date
[case ref], [Date], [Arreas]
1, 7/7/2013, 94.14
1, 1/9/2013, 126.11
and so on
It would be better to transform your data. But it's possible with a synthetic dimension too, just not practical with a lot of date values. See attached example.