Hi SALTO,
thx for your reply.
I try to describe my problem more precisely. I have a excelfile with 3 columns.
First column is the date. Second column the name of the workshop and the third one (Daten_Vorgang) describes how often the workshop tried to access on our servers. The original data gives me the values by calenderweek, but i need it by month, so i connected my table with my mastercalendar.
Next step was to create a tablediagramm with the workshops as dimension.
As basic expressions I calculate :
1.) the actual monthvalues over the workshops:
=sum({$<MonthDiff={[$(vAktuellerMonat)]}>}Daten_Vorgang)
2.) the monthvalue of the month before actual month
=sum({$<MonthDiff={[$(vZeitraum2Monate)]}>}Daten_Vorgang)
3.) The monthvalue 3 month ago:
=sum({$<MonthDiff={[$(vZeitraum3Monate)]}>}Daten_Vorgang)
These expressions above I use in a fourth expression for calculating the 3 month average:
4.) (sum({$<MonthDiff={[$(vAktuellerMonat)]}>}Daten_Vorgang)+
sum({$<MonthDiff={[$(vZeitraum2Monate)]}>}Daten_Vorgang)+
sum({$<MonthDiff={[$(vZeitraum3Monate)]}>}Daten_Vorgang))/3
5.) The next Expression evaluates if the actual monthvalue is greater than the average expression in (4.)
If((sum({$<MonthDiff={[$(vAktuellerMonat)]}>Daten_Vorgang)>
sum({$<MonthDiff={[$(vAktuellerMonat)]}>Daten_Vorgang)+
sum({$<MonthDiff={[$(vZeitraum2Monate)]}>}Daten_Vorgang)+
sum({$<MonthDiff={[$(vZeitraum3Monate)]}>}Daten_Vorgang))/3,1,0)
6.) The last expression just gives me the total numbers of distinct workshops accessing the server up to now :
Count(distinct(WS_Vorgang)
For 5.) and 6.) I see a "1" in the diagramm if the condition is fullfilled otherwise "0". To see the TOTAL Value of the 1´s over all workshops, I activated the corresponding option in the diagrammsettings.
With These total values i want to create a new diagramm with a quote per month: Total value of 5.) / Total value of.6)
But no formula i am trying works untill now
The requirement is to show these quotes in a 12 month diagramm.
Hope its more clear now!
Any ideas?
