Forum Discussion
Help with table with calculated colum
Hello everyone,
I'm looking forward to get your insight and discover what I'm doing wrong here... I have a set of data that I'd like to add into a matrix to display in a very specific format. Let's say I have:
Server Name Open Inc Resolved Inc Priority Server A 43 18 P1 Server A 24 24 P2 Server B 8 3 P1 Server A 21 12 P3 Server B 17 17 P4
And I'd like to present it as:
Server Name P1 P2 P3 P4 Server A 43 / 18 24 / 24 21 / 12 Server B 8 / 3 17 / 17
So I've created a new calculated colum wiith the following formula:
Join CR = CONCATENATE(COUNTA('Incidents'[Created]),CONCATENATE(" / ", COUNTA('Incidents'[Resolved])))
That formula gives me the format, but also the total number on each column, not individual values by column:
Server Name P1 P2 P3 P4 Server A 113 / 74 113 / 74 113 / 74 Server B 113 / 74 113 / 74
Can't seem to find a way to make it for each individual colum (priority)!
All your comments are welcome... :)
Use a measure instead of a calculated column. Put Server Name in rows, Priority in columns and your measure in Values.
Hi veng2002,
You can create a measure with below:
Join CR = CONCATENATE(MAX('Incidents'[Open Inc ]),CONCATENATE(" / ", MAX('Incidents'[Resolved Inc])))
Then use a matrix visual to display data:
Best Regards,
Qiuyun Yu
2 Replies
Use a measure instead of a calculated column. Put Server Name in rows, Priority in columns and your measure in Values.
Hi veng2002,
You can create a measure with below:
Join CR = CONCATENATE(MAX('Incidents'[Open Inc ]),CONCATENATE(" / ", MAX('Incidents'[Resolved Inc])))
Then use a matrix visual to display data:
Best Regards,
Qiuyun Yu