Hello Everyone.
I want to make Get sum of column and percentage of it (source by csv data)
How can i do that?
| CodeSonar_All_Issue | Percantage | |
|---|---|---|
| Jul 31 2019 | 8 | 20% |
| Aug 01 2019 | 3 | 7% |
| Aug 05 2019 | 3 | 7% |
| Aug 07 2019 | 1 | 2% |
| Aug 08 2019 | 2 | 5% |
| Aug 12 2019 | 3 | 7% |
| Aug 13 2019 | 2 | 5% |
| Aug 15 2019 | 1 | 2% |
| Aug 19 2019 | 4 | 10% |
| Aug 20 2019 | 6 | 15% |
| Aug 21 2019 | 8 | 20% |
This question resolved.
Created as shown below.
CASE WHEN
([Measures].[CodeSonar_All_Issue],
[First_Detect_Time].DefaultMember)>0
THEN
[Measures].[CodeSonar_All_Issue] /
([Measures].[CodeSonar_All_Issue], [First_Detect_Time].DefaultMember)
END
Hi @bbyoo
I am super happy that you found the answer to your challenge.
Just wanted to share the link to our documentation page where we have described how to enable standart calculated functions from the UI.
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Addstandardcalculationsbasedonaselectedmeasure
Martins / eazyBI team
