Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have created a chart containing two(2) calculated dimensions and a count expression to display the aging of audit dates.
Month(Computer_List_All.LastAuditDate)
Year(Computer_List_All.LastAuditDate)
count(Computer_List_All.Asset_Tag)
I have 15 records in the database which do not have an 'Audit Date'. I have a questions here, how to show the records with no 'Audit Date' in the chart?
Thanks, any help is welcome,
Matthias
This is the result:
Have you try to tick the "Show All Values" option on the properties options of the Graph ??
Properties > Dimensions > Panel "Settings For Selected Dimension"
Hope this will help.
On presentation Tab, ensure Suppress Zero-Values and Suppress Missing are not checked
Thanks for your answer, it is not checked.
I loaded following sample data
Load Inline
Year Month Audit
2005 Jan 1
2005 Feb 1
2005 Mar 0 etc...
Audit = 1 when audit was performed, Audit=0 for No Audit
Dimensions in chart = Year, Month
Expression: Audit
Presentation tab : Ensured no suppression was taking place
Background colour of expression :
IF
(Audit = 1,green(),lightred())
My chart shows Months with Audit as green bubble and months with missing audit as red... sorry, don't know how to paste image
LOAD * INLINE [
Year, Month, Audit
2005, Jan, 1
2005, Feb, 1
2005, Mar, 1
2005, April, 1
2005, May, 0
2005, Jun, 0
2005, Jul, 1
2005, Aug, 1
2005, Sep, 0
2005, Oct, 1
2005, Nov, 1
2005, Dec, 1
2006, Jan, 0
2006, Feb, 1
2006, Mar, 1
2006, April, 1
2006, May, 1
2006, Jun, 1
2006, Jul, 0
2006, Aug, 1
2006, Sep, 1
2006, Oct, 1
2006, Nov, 0
2006, Dec, 1
];
Hi Bismart,
sorry for being not clear in my original post I am not interested in the fact that an audit has happened, I am interested in how many computers have been auditedand in which month, like an aging. I am counting the computers to find out how the distribution of the audit dates is. E.g. I know that 699 computers have been audited in July 2009 and 143 in June 2009 and ..... The target for me is to audit all in one month.
Thanks for your help.
Hi,
If i can not show the count with empty Year and Month, how to fill the empty year and month with a default date?
Thanks